{"id":929,"date":"2017-05-10T10:23:22","date_gmt":"2017-05-10T01:23:22","guid":{"rendered":"https:\/\/oboki.net\/?p=929"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tbexport-tbimport","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tbexport-tbimport\/","title":{"rendered":"[Tibero] tbExport\/tbImport"},"content":{"rendered":"

tbExport\/tbImport<\/h1>\n

\n Tibero\ub97c \uc124\uce58\ud558\uba74 $TB_HOME\/client\/bin<\/code> \uacbd\ub85c\uc5d0 \uae30\ubcf8\uc801\uc73c\ub85c \ud3ec\ud568\ub41c \uc720\ud2f8\ub9ac\ud2f0\ub85c, tbExport<\/code>\ub294 Tibero \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\uc758 \uc804\uccb4\ub098 \uc77c\ubd80\ub97c \ud30c\uc77c\ub85c \ucd94\ucd9c\ud558\uba70, \ucd94\ucd9c\ub41c \ub364\ud504 \ud30c\uc77c\uacfc tbImport<\/code>\ub97c \uc774\uc6a9\ud574\uc11c Tibero\uc5d0 \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4.\n<\/p><\/blockquote>\n

\n

tbExport<\/h2>\n

\ubaa8\ub4dc<\/h3>\n
    \n
  • \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub4dc\n
      \n
    • Tibero \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \ub364\ud504\ud558\ub294 \ubaa8\ub4dc\ub85c \uc544\ub798 \ud30c\ub77c\ubbf8\ud130 \uc9c0\uc815\uc73c\ub85c \uc124\uc815\ud560 \uc218 \uc788\ub2e4.<\/li>\n
    • FULL=Y<\/code><\/li>\n<\/ul>\n<\/li>\n
    • \uc0ac\uc6a9\uc790 \ubaa8\ub4dc\n
        \n
      • \uc9c0\uc815\ub41c \uc0ac\uc6a9\uc790\uc758 \ubaa8\ub4e0 \uac1d\uccb4\ub97c \ub364\ud504\ud558\ub294 \ubaa8\ub4dc\ub85c \uc544\ub798\uc640 \uac19\uc774 userlist\ub97c \uc9c0\uc815\ud574\uc11c \uc124\uc815\ud560 \uc218 \uc788\ub2e4.<\/li>\n
      • USER=TIBERO,TIBERO1,SCOTT,...<\/code><\/li>\n<\/ul>\n<\/li>\n
      • \ud14c\uc774\ube14 \ubaa8\ub4dc\n
          \n
        • \uc544\ub798 tablelist\ub85c \uc9c0\uc815\ub41c \ud14c\uc774\ube14\uacfc \uc5f0\uad00\ub41c \uc778\ub371\uc2a4 \ub4f1\uc758 \uac1d\uccb4\ub97c \ub364\ud504\ud558\ub294 \ubaa8\ub4dc\uc774\ub2e4.<\/li>\n
        • TABLE=USER1.TAB1,USER1.TAB2,USER2.TAB3,...<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          \uc2e4\ud589 \ubc29\ubc95<\/h3>\n

          \uc544\ub798\uc640 \uac19\uc774 command-line \uc5d0\uc11c \uc635\uc158\uc744 \uc120\uc5b8\ud574\uc904 \uc218\ub3c4 \uc788\uace0,<\/p>\n

          tbexport username=tibero password=tmax sid=tibero file=tbExp.dat log=tbExp.log full=y<\/code><\/p>\n

          \ubcc4\ub3c4\ub85c \ud30c\ub77c\ubbf8\ud130\ub97c \uc124\uc815\ud574\ub454 .cfg<\/code> \ud30c\uc77c\uc744 \uc774\uc6a9\ud560 \uc218\ub3c4 \uc788\ub2e4.<\/p>\n

          tbexport cfgfile=tbExp.cfg<\/code><\/p>\n

          \ud30c\ub77c\ubbf8\ud130<\/h3>\n
            \n
          • CFGFILE<\/code>\n
              \n
            • CFG \ud30c\uc77c \uacbd\ub85c<\/code> (tbExp.cfg<\/code>)<\/li>\n
            • command-line \uc73c\ub85c \ud30c\ub77c\ubbf8\ud130\ub97c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \ubcc4\ub3c4\ub85c \ud30c\ub77c\ubbf8\ud130\ub97c \uae30\ub85d\ud574\ub454 \ud30c\uc77c\uc744 \uc774\uc6a9\ud574\uc11c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ud574\ub2f9 \ud30c\uc77c\uc758 \ud30c\uc77c\uba85\uc744 \uae30\uc785<\/li>\n<\/ul>\n<\/li>\n
            • COMPRESS<\/code>\n
                \n
              • Y<\/code> | N<\/code><\/li>\n
              • \ucd94\ucd9c\ud558\ub294 \ub3d9\uc2dc\uc5d0 \uc555\ucd95\uc744 \uc218\ud589\ud558\uace0\uc790\ud558\ub294 \uacbd\uc6b0 Y<\/code>\ub85c \uc120\uc5b8\ud558\uba70, \uc774 \ub54c\uc5d0\ub294 \ub2e8\uc77c \uc2a4\ub808\ub4dc\ub85c\ub9cc \ub3d9\uc791<\/li>\n<\/ul>\n<\/li>\n
              • CONSTRAINT<\/code> Export Constraint: Y\/N, default: Y\n
                  \n
                • Y<\/code> | N<\/code><\/li>\n
                • CONSTRAINT \ucd94\ucd9c \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                • CONSISTENT<\/code>\n
                    \n
                  • Y<\/code> | N<\/code><\/li>\n
                  • tbExport<\/code> \uc218\ud589 \uc2dc\uc810 \uae30\uc900 consistency \ubcf4\uc7a5 \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                  • ENCRYPTION<\/code>\n
                      \n
                    • ALL<\/code> | DATA_ONLY<\/code> | ENCRYPTED_COLUMNS_ONLY<\/code> | METADATA_ONLY<\/code> | NONE<\/code><\/li>\n
                    • AES-128<\/code> \uc54c\uace0\ub9ac\uc998\uc73c\ub85c \uc554\ud638\ud654 \ud560 \ub300\uc0c1 \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n
                    • ENCRYPTION_PASSWORD<\/code>\n
                        \n
                      • password<\/code><\/li>\n
                      • \uc554\ud638\ud654\ub97c \uc9c4\ud589\ud558\ub294 \uacbd\uc6b0 \ub364\ud504 \ud30c\uc77c\uc5d0 \uc801\uc6a9\ud560 \uc554\ud638 \uc124\uc815<\/li>\n<\/ul>\n<\/li>\n
                      • EXCLUDE<\/code>\n
                          \n
                        • \uc2a4\ud0a4\ub9c8 \ubc0f schema.table \uc81c\uc678<\/li>\n
                        • EXCLUDE=schema:\\\"=\\'TIBERO\\'\/table:LIKE \\'T%\\'\\\"<\/code><\/li>\n
                        • EXCLUDE=schema:\\\"IN\\'USER1\\'\\\"<\/code><\/li>\n
                        • \uc5ec\ub7ec\uac1c \uc2a4\ud0a4\ub9c8 \uc81c\uc678<\/li>\n
                        • EXCLUDE=schema:\\\"=\\'TIBERO\\'\\\"<\/code><\/li>\n
                        • EXCLUDE=schema:\\\"=\\'USER1\\'\\\"<\/code><\/li>\n
                        • \uc5ec\ub7ec\uac1c \ud14c\uc774\ube14 \uc81c\uc678<\/li>\n
                        • EXCLUDE=table:\\\"LIKE\\'E%\\'\\\"<\/code><\/li>\n
                        • EXCLUDE=table:\\\"LIKE\\'E%\\'\\\"<\/code><\/li>\n
                        • \ud2b9\uc815 \uc0ac\uc6a9\uc790\ub098 \ud14c\uc774\ube14\uc744 \uc81c\uc678\ud558\uace0 \ucd94\ucd9c<\/li>\n<\/ul>\n<\/li>\n
                        • FULL<\/code>\n
                            \n
                          • Y<\/code> | N<\/code><\/li>\n
                          • \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub4dc\ub85c \ucd94\ucd9c\ud560\uc9c0 \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                          • USER<\/code>\n
                              \n
                            • \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \ub9ac\uc2a4\ud2b8<\/code><\/li>\n
                            • \uc0ac\uc6a9\uc790 \ubaa8\ub4dc\ub85c \ucd94\ucd9c\ud558\uace0\uc790\ud558\ub294 \uacbd\uc6b0, \uc0ac\uc6a9\uc790 \ub9ac\uc2a4\ud2b8<\/li>\n<\/ul>\n<\/li>\n
                            • TABLE<\/code>\n
                                \n
                              • \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8<\/code><\/li>\n
                              • \ud14c\uc774\ube14 \ubaa8\ub4dc\ub85c \ucd94\ucd9c\ud558\uace0\uc790\ud558\ub294 \uacbd\uc6b0, \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8<\/li>\n<\/ul>\n<\/li>\n
                              • GEOM_ASBYTES<\/code> Export the geometry columns as bytes, default: N<\/li>\n
                              • GRANT<\/code>\n
                                  \n
                                • Y<\/code> | N<\/code><\/li>\n
                                • \ucd94\ucd9c \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad8c\ud55c\uc744 \uadf8\ub300\ub85c \ucd94\ucd9c\ud560\uc9c0 \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                                • INDEX<\/code>\n
                                    \n
                                  • Y<\/code> | N<\/code><\/li>\n
                                  • INDEX \ucd94\ucd9c \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                                  • INLINE_CONSTRAINT<\/code>\n
                                      \n
                                    • Y<\/code> | N<\/code><\/li>\n
                                    • INDEX \ucd94\ucd9c\uc740 INDEX \uc0dd\uc131 \uad6c\ubb38\uc73c\ub85c \ucd94\ucd9c\ud558\ub294\ub370, CONSTRAINT\ub97c \ucd94\ucd9c\ud560 \ub54c INDEX \uc0dd\uc131 \uad6c\ubb38\uc5d0 INLINE\uc73c\ub85c \ud560 \uc9c0 \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                                    • FILE<\/code>\n
                                        \n
                                      • \ud30c\uc77c\uba85<\/code><\/li>\n
                                      • \ub364\ud504 \ud30c\uc77c\uba85 \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n
                                      • LOG<\/code>\n
                                          \n
                                        • \ud30c\uc77c\uba85<\/code><\/li>\n
                                        • \uc791\uc5c5\ub85c\uadf8 \ud30c\uc77c\uba85 \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n
                                        • LOGDIR<\/code>\n
                                            \n
                                          • \ud30c\uc77c\uacbd\ub85c<\/code><\/li>\n
                                          • \uc791\uc5c5\ub85c\uadf8 \uacbd\ub85c \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n
                                          • NO_PACK_DIR<\/code>\n
                                              \n
                                            • \ud30c\uc77c\uacbd\ub85c<\/code><\/li>\n
                                            • \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd94\ucd9c\ud55c \ub4a4 \ub2e8\uc77c \ud30c\uc77c\ub85c packing\ud558\uc9c0 \uc54a\uace0\uc790 \ud558\ub294 \uacbd\uc6b0, \ub364\ud504 \ud30c\uc77c\uc774 \uc313\uc77c \uacbd\ub85c\ub97c \uc9c0\uc815. tbexport<\/code>\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd94\ucd9c\ud560 \ub54c, \uac1d\uccb4 \ub2e8\uc704\ub85c \ucd94\ucd9c\ud558\uc5ec \ub2e8\uc77c \ud30c\uc77c\ub85c \ud328\ud0b9\ud558\uae30 \ub54c\ubb38\uc5d0 \ub364\ud504\ud30c\uc77c\uc758 \ub450 \ubc30 \uac00\ub7c9\uc758 \uc5ec\uc720 \uacf5\uac04\uc774 \ud544\uc694. \ucd94\ucd9c\ud558\ub294 \uc11c\ubc84\uc5d0 \uc5ec\uc720 \uacf5\uac04\uc774 \uc5c6\ub294 \uacbd\uc6b0 \uc0ac\uc6a9.<\/li>\n<\/ul>\n<\/li>\n
                                            • OVERWRITE<\/code>\n
                                                \n
                                              • Y<\/code> | N<\/code><\/li>\n
                                              • \ub3d9\uc77c\ud55c \uc774\ub984\uc758 \ud30c\uc77c\uc774 \uc874\uc7ac\ud558\ub294 \uacbd\uc6b0 overwrite \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                                              • IP<\/code>\n
                                                  \n
                                                • IP=192.168.86.29<\/code><\/li>\n
                                                • Tibero \uc11c\ubc84 IP \uc8fc\uc18c<\/li>\n<\/ul>\n<\/li>\n
                                                • PORT<\/code>\n
                                                    \n
                                                  • PORT=8629<\/code><\/li>\n
                                                  • Tibero \uc11c\ubc84 Listener Port<\/li>\n<\/ul>\n<\/li>\n
                                                  • SID<\/code>\n
                                                      \n
                                                    • SID=TIBERO<\/code><\/li>\n
                                                    • Tibero \uc11c\ubc84\uc758 Database Name<\/li>\n<\/ul>\n<\/li>\n
                                                    • USERNAME<\/code>\n
                                                        \n
                                                      • USERNAME=SYS<\/code><\/li>\n
                                                      • tbexport \ud504\ub85c\uadf8\ub7a8\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd94\ucd9c\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uadfc\ud560 \uc0ac\uc6a9\uc790. \ucd94\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac1d\uccb4\ub4e4\uc5d0 \ub300\ud55c \ucda9\ubd84\ud55c \uad8c\ud55c\uc774 \ud544\uc694.<\/li>\n<\/ul>\n<\/li>\n
                                                      • PASSWORD<\/code>\n
                                                          \n
                                                        • PASSWORD=TIBERO<\/code><\/li>\n
                                                        • USERNAME<\/code> \uc0ac\uc6a9\uc790\uc758 DB \uc811\uadfc \uc554\ud638<\/li>\n<\/ul>\n<\/li>\n
                                                        • SAVE_CREDENTIAL<\/code>\n
                                                            \n
                                                          • \uc544\ub798 \ud65c\uc6a9 \uc608\uc5d0\uc11c \uc0ac\uc6a9 \ubc29\ubc95 \ubcc4\ub3c4 \uc124\uba85<\/li>\n
                                                          • \ucd94\ucd9c\uc744 \uc704\ud574 DB \uc11c\ubc84 \uc811\uadfc\uc2dc, EXPIMP_WALLET<\/code> \uc2dc\uc2a4\ud15c \ud658\uacbd\ubcc0\uc218\ub85c \uc9c0\uc815\ub41c Credential \ud30c\uc77c\uc5d0 \uc554\ud638\ud654\ud558\uc5ec \uc800\uc7a5\ub41c Username\uacfc password \uc0ac\uc6a9<\/li>\n<\/ul>\n<\/li>\n
                                                          • QUERY<\/code>\n
                                                              \n
                                                            • QUERY='\\where rownum>10\\'<\/code><\/li>\n
                                                            • Export\ub420 \ub370\uc774\ud130\uc5d0 where<\/code> \ud544\ud130\ub97c \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n
                                                            • REMAP_TABLESPACE<\/code>\n
                                                                \n
                                                              • REMAP_TABLESPACE=USR1:USR3,USR2:USR4<\/code><\/li>\n
                                                              • \ucd94\ucd9c\uc2dc \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uba85\uc744 \ubcc0\uacbd.<\/li>\n<\/ul>\n<\/li>\n
                                                              • REMAP_TABLE<\/code>\n
                                                                  \n
                                                                • REMAP_TABLE=T1:T3,T2:T4<\/code><\/li>\n
                                                                • \ucd94\ucd9c\uc2dc \ud14c\uc774\ube14 \uba85\uc744 \ubcc0\uacbd<\/li>\n<\/ul>\n<\/li>\n
                                                                • ROWS<\/code>\n
                                                                    \n
                                                                  • Y<\/code> | N<\/code><\/li>\n
                                                                  • \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud560 \uc9c0 \uc5ec\ubd80. N<\/code> \uc73c\ub85c \uc124\uc815\ud558\ub294 \uacbd\uc6b0 \ud14c\uc774\ube14 \uad6c\uc870\ub9cc \ucd94\ucd9c<\/li>\n<\/ul>\n<\/li>\n
                                                                  • SCRIPT<\/code>\n
                                                                      \n
                                                                    • Y<\/code> | N<\/code><\/li>\n
                                                                    • \ucd94\ucd9c\ub41c DDL Script\ub97c \ub85c\uadf8\uc5d0 \ud3ec\ud568\uc2dc\ud0ac\uc9c0 \uc5ec\ubd80<\/li>\n<\/ul>\n<\/li>\n
                                                                    • TEMP_DIR<\/code>\n
                                                                        \n
                                                                      • \ud30c\uc77c\uacbd\ub85c<\/code><\/li>\n
                                                                      • raw \ub364\ud504 \ud30c\uc77c\ub4e4\uc774 \uc784\uc2dc\ub85c \uc0ac\uc6a9\ub420 \uacbd\ub85c \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n
                                                                      • THREAD_CNT<\/code>\n
                                                                          \n
                                                                        • Number<\/code> (default: 4)<\/li>\n
                                                                        • \ud14c\uc774\ube14\uc744 \ucd94\ucd9c\ud560 \ub54c \uc0ac\uc6a9\ub418\ub294 Thread \uac1c\uc218 \uc9c0\uc815<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                                                          \ud65c\uc6a9 \uc608<\/h3>\n

                                                                          \n EXPIMP_WALLET \uc744 \uc774\uc6a9\ud558\uc5ec \uc554\ud638\ud654\ub41c \uc811\uc18d \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec \uc11c\ubc84\uc5d0 \uc811\uadfc\ud558\uba70, \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucd94\ucd9c\ud558\ub294 \uacbd\uc6b0\n<\/p><\/blockquote>\n

                                                                          \uba3c\uc800 EXPIMP_WALLET \ud30c\uc77c\uc744 \uc900\ube44\ub3fc\uc788\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

                                                                          export EXPIMP_WALLET=~\/exp\/.expimp_wallet\ntbexport save_credential=$EXPIMP_WALLET username=tibero password=tmax\nls $EXPIMP_WALLET\n<\/code><\/pre>\n
                                                                          \uc544\ub798\uc640 \uac19\uc774 Credential \uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc800\uc7a5\ub418\uc5c8\ub2e4\uace0 \ucd9c\ub825\ub418\uba74 \uc774\ud6c4 tbexport \uc720\ud2f8\uc744 \uc2e4\ud589\ud560 \ub54c\ubd80\ud130\ub294 username<\/code>\uacfc password<\/code>\ub97c \uc9c0\uc815\ud558\uc9c0 \uc54a\ub354\ub77c\ub3c4 DB \uc11c\ubc84\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub2e4. tbExport\ub97c \uc774\uc6a9\ud55c \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 DB \uc811\uc18d \uc815\ubcf4\uac00 \ud45c\uae30\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uc798 \ud65c\uc6a9\ud558\uba74 \ud328\uc2a4\uc6cc\ub4dc \ub178\ucd9c\uc744 \ub9c9\uc744 \uc218 \uc788\ub2e4.<\/p>\n
                                                                          Credential saved: ~\/exp\/.expimp_wallet\n<\/code><\/pre>\n
                                                                          TIBERO1<\/code> \uc2a4\ud0a4\ub9c8\ub97c \uc81c\uc678\ud55c \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\ub97c \ucd94\ucd9c\ud558\ub294 CFGFILE\uc744 \uc791\uc131\ud55c\ub2e4.<\/p>\n
                                                                          vi tbExp.cfg<\/code><\/p>\n
                                                                          FULL=Y\nSCRIPT=Y\nCONSISTENT=Y\nOVERWRITE=Y\nEXCLUDE=schema:\\\"='\\TIBERO1\\'\"\nFILE=tbExp.dat\nLOG=tbExp.log\nIP=127.0.0.1\nPORT=8629\nSID=tibero\n<\/code><\/pre>\n
                                                                          \ub2e4\uc74c \uba85\ub839\uc744 \uc218\ud589\ud558\uba74 username<\/code>\uacfc password<\/code> \uc5c6\uc774 \ucd94\ucd9c\uc774 \uc218\ud589\ub418\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n
                                                                          tbexport CFGFILE=tbExp.cfg<\/code><\/p>\n
                                                                          \n
                                                                          tbImport<\/h2>\n
                                                                          \uc2e4\ud589 \ubc29\ubc95<\/h3>\n
                                                                          tbimport username=tibero password=tmax sid=tibero file=tbExp.dat log=tbImp.log full=y<\/code><\/p>\n
                                                                          \ub610\ub294<\/p>\n
                                                                          tbimport cfgfile=import.cfg<\/code><\/p>\n
                                                                          \ud30c\ub77c\ubbf8\ud130<\/h3>\n
                                                                          \uc77c\ubc18\uc801\uc73c\ub85c tbexport<\/code>\uc5d0\uc11c \ucd94\ucd9c\ud55c \ud30c\uc77c\uc744 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc73c\ubbc0\ub85c, \uc704 \uc2e4\ud589 \ubc29\ubc95\uc5d0 \ub098\uc628 \uad6c\ubb38\uc73c\ub85c \uc218\ud589\ud558\uba74 \ub41c\ub2e4.<\/p>\n
                                                                          \uc138\ubd80\uc801\uc778 \uc635\uc158\uc740 tbimport<\/code> \uba85\ub839\uc744 \uc218\ud589\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0ac\uc6a9\ubc95 \ubc0f \ud30c\ub77c\ubbf8\ud130 \uc124\uba85\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n
                                                                          tbimport 6.0  xxxxxx Copyright 2015 TmaxData Co., Ltd. All Rights Reserved.\nPatch files (none)\n\nUsage:  tbimport [PARAMETER1=VALUE] [PARAMETER2=VALUE] ...\nParameters:\n    BIND_BUF_SIZE     Specify the buffer size of DPL stream, default: 1M(1048576)\n    CFGFILE           Config file name\n    COMMIT            Commit after the insertion, default: N\n    CONSTRAINT        Import Constraint: Y\/N, default: Y\n    DBLINK            Import DB Link: Y\/N, default: Y\n    DPL               Use Direct Path Load: Y\/N, default: N\n    ENCRYPTION_PASSWORD    encryption password to decrypt dump file\n    EXP_SERVER_VER    Specify the exported server version, default: 8\n    FILE              Import dump file name, default: default.dat\n    FROMUSER          FromUser toUser Mode: user name list(must be used with TOUSER parameter) \n    FULL              Full Mode: Y\/N, default: N\n    GRANT             Import Grant: Y\/N, default: Y\n    GEOM_ASBYTES      Import the data to the geometry columns as bytes, default: N\n    IGNORE            Ignore create error due to object existence: Y\/N, default: N\n    INDEX             Import Index: Y\/N, default: Y\n    IO_BUF_SIZE       Specify the buffer size of file I\/O, default: 16M(16777216)\n    IP                IP address, default: localhost\n    LOG               Import script log file name\n    LOGDIR            Import log directory\n    NATIONAL_CHARSET  Specify the exported national character set, default is the exported character set \n    NO_PACK_DIR       Import unpacked dump files from specified directory. If this option is specified, FILE parameter will be ignored.\n    PASSWORD          User password\n    ROLE              Import Role: Y\/N, default: Y\n    PORT              PORT number, default: 8629\n    PSM               Import PSM: Y\/N, default: Y\n    P_DPL             Use Parallel DPL: Y\/N, default: N\n    ROWS              Import Table Rows: Y\/N, default: Y\n    SAVE_CREDENTIAL   Save your username and password to specified file\n    SCRIPT            LOG THE DDL SCRIPT: Y\/N, default: N\n    SEQUENCE          Import Sequence: Y\/N, default: Y\n    SID               Database name\n    STATISTICS       Import Statistics: Y\/N, default: N\n    SYNONYM           Import Synonym: Y\/N, default: Y\n    TABLE             Table Mode: table name list\n    TEMP_DIR          Directory for the temporary raw dump files.\n    THREAD_CNT        Thread Count, default: 4\n    TOUSER            FromUser toUser Mode: user name list(must be used with FROMUSER parameter) \n    TRIGGER           Import Trigger: Y\/N, default: Y\n    USER              User Mode: user name list \n    USERNAME          Database user name\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
                                                                          tbExport\/tbImport Tibero\ub97c \uc124\uce58\ud558\uba74 $TB_HOME\/client\/bin \uacbd\ub85c\uc5d0 \uae30\ubcf8\uc801\uc73c\ub85c \ud3ec\ud568\ub41c \uc720\ud2f8\ub9ac\ud2f0\ub85c, tbExport\ub294 Tibero \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1d\uccb4\uc758 \uc804\uccb4\ub098 \uc77c\ubd80\ub97c \ud30c\uc77c\ub85c \ucd94\ucd9c\ud558\uba70, \ucd94\ucd9c\ub41c \ub364\ud504 \ud30c\uc77c\uacfc tbImport\ub97c \uc774\uc6a9\ud574\uc11c Tibero\uc5d0 \ub370\uc774\ud130\ub97c \ub2e4\uc2dc \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4. tbExport \ubaa8\ub4dc \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub4dc Tibero \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \ub364\ud504\ud558\ub294 \ubaa8\ub4dc\ub85c \uc544\ub798 \ud30c\ub77c\ubbf8\ud130 \uc9c0\uc815\uc73c\ub85c \uc124\uc815\ud560 \uc218 \uc788\ub2e4. FULL=Y \uc0ac\uc6a9\uc790 \ubaa8\ub4dc \uc9c0\uc815\ub41c \uc0ac\uc6a9\uc790\uc758 \ubaa8\ub4e0 \uac1d\uccb4\ub97c \ub364\ud504\ud558\ub294 \ubaa8\ub4dc\ub85c \uc544\ub798\uc640 \uac19\uc774 userlist\ub97c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[136,89,23],"class_list":["post-929","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-backup","tag-database","tag-tibero"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=929"}],"version-history":[{"count":4,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/929\/revisions"}],"predecessor-version":[{"id":1307,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/929\/revisions\/1307"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}