{"id":117,"date":"2017-03-29T17:03:09","date_gmt":"2017-03-29T08:03:09","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=117"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tibero-tbexport-remap_tablespace","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero-tbexport-remap_tablespace\/","title":{"rendered":"[Tibero] tbexport &#8211; remap_tablespace"},"content":{"rendered":"<h2>\uc2e4\uc2b5\uc6a9 \uc608\uc81c user,table \uc0dd\uc131<\/h2>\n<pre><code>#!\/bin\/bash\n#2017\/03\/29\n#testcase_mig_fk.sh\n#dong1lkim\n\nTBL_CNT=0 #init TBL_CNT\nwhile (($TBL_CNT &lt;= 500))\ndo\n    PKTAB_NAME=TBL_PKTEST_<code>echo $TBL_CNT<\/code>\n    FKTAB_NAME=TBL_FKTEST_<code>echo $TBL_CNT<\/code>\n    sh cre_fktab.sh\n        echo $filename\n        ROW_CNT=0 #init cnt\n        while (($ROW_CNT &lt;= 500))\n        do\n        sh insert_val_fktab.sh\n        let ROW_CNT+=1\n    done\n    let TBL_CNT+=1\n        echo -e \"loop ends\"\ndone\n\n#!\/BIN\/BASH\n#2017\/03\/29\n#cre_fktab.sh\n#DONG1LKIM\n\ntbsql -s fktest2\/tibero &lt;&lt;EOF\n--SET ECHO ON --DEBUGGING\n\/*\nCREATE TABLE $PKTAB_NAME (PK NUMBER\n        , PKTAB_COLA NUMBER\n        , PKTAB_COLB NUMBER\n        , PKTAB_COLC NUMBER\n        ); \nCREATE INDEX PK_<code>echo $PKTAB_NAME<\/code> ON $PKTAB_NAME (PK) ONLINE NOLOGGING;\nALTER TABLE $PKTAB_NAME ADD PRIMARY KEY(PK) USING INDEX PK_<code>echo $PKTAB_NAME<\/code> ENABLE;\n*\/\nCREATE TABLE $PKTAB_NAME (PK NUMBER primary key\n        , PKTAB_COLA NUMBER\n        , PKTAB_COLB NUMBER\n        , PKTAB_COLC NUMBER\n        ); \nCREATE TABLE $FKTAB_NAME (FK NUMBER\n        , PKTAB_COLA NUMBER\n        , PKTAB_COLB NUMBER\n        , PKTAB_COLC NUMBER\n        , CONSTRAINT FK_<code>echo $FKTAB_NAME<\/code> FOREIGN KEY (FK) REFERENCES $PKTAB_NAME(PK)\n        );\n\n\/*\nCREATE TABLE $FKTAB_NAME (FK NUMBER\n        , PKTAB_COLA NUMBER\n        , PKTAB_COLB NUMBER\n        , PKTAB_COLC NUMBER\n        );\nALTER TABLE $FKTAB_NAME ADD FOREIGN KEY(FK) REFERENCES $PKTAB_NAME(PK);\n*\/\nEXIT\n\/\nEOF\n\n#!\/bin\/bash\n#2017\/03\/29\n#insert_val_fktab.sh\n#dong1lkim\n\ntbsql -s fktest2\/tibero &lt;&lt;EOF\nINSERT INTO $PKTAB_NAME VALUES($ROW_CNT,$ROW_CNT,$ROW_CNT,$ROW_CNT);\nINSERT INTO $FKTAB_NAME VALUES($ROW_CNT,$ROW_CNT,$ROW_CNT,$ROW_CNT);\nEOF\n<\/code><\/pre>\n<h2>\uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4 export \ubc31\uc5c5<\/h2>\n<pre><code>#FKTEST \uc18c\uc720 \ud14c\uc774\ube14 \ubcc4\ub3c4 \uad00\ub9ac\ud558\uae30 \uc704\ud574 usermode, remap_tablespace=usr:TBS_FKT_DAT \uc635\uc158\uc73c\ub85c \ud55c \ubc8c\ntbexport username=sys password=tibero sid=tibero port=8629 user=fktest script=y rows=y index=n constraint=n remap_tablespace=usr:TBS_FKT_DAT file=exp_fkt_dat.dat log=exp_fkt_dat.log\n#FKTEST \uc18c\uc720 \uc778\ub371\uc2a4 \ubcc4\ub3c4 \uad00\ub9ac\ud558\uae30 \uc704\ud574 usermode, remap_tablespace=usr:TBS_FKT_IDX \uc635\uc158\uc73c\ub85c \ud55c \ubc8c\ntbexport username=sys password=tibero sid=tibero port=8629 user=fktest script=y rows=n index=y constraint=y remap_tablespace=usr:TBS_FKT_IDX  file=exp_fkt_idx.dat log=exp_fkt_idx.log\n#\ubd84\ub9ac\ud558\uace0\uc790 \ud558\ub294 \uc5c5\ubb34 \uc678 \ud14c\uc774\ube14\/\uc778\ub371\uc2a4, role, function \uc774\uad00\uc744 \uc704\ud574 full \ubaa8\ub4dc \ud55c \ubc8c\ntbexport username=sys password=tibero sid=tibero port=8629 full=y \n file=exp_full.dat log=exp_full_dat.log\n<\/code><\/pre>\n<h2>import \uc774\uad00<\/h2>\n<pre><code>#\uc774\uad00 \uc18d\ub3c4 \ud5a5\uc0c1 \ubc0f \uc778\ub371\uc2a4 \ubd84\ub9ac\ub97c \uc704\ud574 \ud14c\uc774\ube14 rows \uba3c\uc800 \uc774\uad00. \uc0ac\uc804\uc5d0 \uc720\uc800,\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uac00 \uc0dd\uc131\ub3fc \uc788\uc5b4\uc57c \ud55c\ub2e4.\ntbimport username=sys password=tibero sid=tibero port=8629 user=fktest script=y rows=y index=n constraint=n file=exp_fkt_dat.dat log=imp_fkt_dat.log\n#\uc774\ud6c4 index,constraint \ubcc4\ub3c4\ub85c \uc774\uad00\ntbimport username=sys password=tibero sid=tibero port=8629 user=fktest script=y rows=n index=y constraint=y file=exp_fkt_idx.dat log=imp_fkt_idx.log\n#\ub204\ub77d\ub41c \ub370\uc774\ud130 \ubc0f object,source \ub4e4\uc744 \uc774\uad00\ud558\uae30 \uc704\ud574 full \ubaa8\ub4dc\ub85c \uc774\uad00.\ntbimport username=sys password=tibero sid=tibero port=8629 full=y file=exp_full.dat log=imp_full_dat.log\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc2e4\uc2b5\uc6a9 \uc608\uc81c user,table \uc0dd\uc131 #!\/bin\/bash #2017\/03\/29 #testcase_mig_fk.sh #dong1lkim TBL_CNT=0 #init TBL_CNT while (($TBL_CNT &lt;= 500)) do PKTAB_NAME=TBL_PKTEST_echo $TBL_CNT FKTAB_NAME=TBL_FKTEST_echo $TBL_CNT sh cre_fktab.sh echo $filename ROW_CNT=0 #init cnt while (($ROW_CNT &lt;= 500)) do sh insert_val_fktab.sh let ROW_CNT+=1 done let TBL_CNT+=1 echo -e &#8220;loop ends&#8221; done #!\/BIN\/BASH #2017\/03\/29 #cre_fktab.sh #DONG1LKIM tbsql -s fktest2\/tibero &lt;&lt;EOF &#8211;SET ECHO ON [&hellip;]<\/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,23],"class_list":["post-117","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-backup","tag-tibero"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/117","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=117"}],"version-history":[{"count":5,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":1319,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/117\/revisions\/1319"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}