{"id":312,"date":"2015-02-26T02:30:54","date_gmt":"2015-02-26T02:30:54","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=312"},"modified":"2015-02-26T02:30:54","modified_gmt":"2015-02-26T02:30:54","slug":"oracle-tts-%eb%a7%88%ec%9d%b4%ea%b7%b8%eb%a0%88%ec%9d%b4%ec%85%98-%ec%9e%91%ec%97%85-%ea%b0%80%ec%9d%b4%eb%93%9c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=312","title":{"rendered":"Oracle TTS \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc791\uc5c5 \uac00\uc774\ub4dc"},"content":{"rendered":"<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>TTS (Transportable Tablespace) \uac1c\uc694<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Transportable Tablespace\uae30\ub2a5\uc740 \uae30\uc874 \ub370\uc774\ud130 \ub85c\ub529 \ubc29\uc2dd\uc774 \uc2e4\uc81c \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud558\uc5ec insert \ud558\ub294 \ubc29\uc2dd\uacfc\ub294 \ub2e4\ub974\uac8c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub2e8\uc704\ub85c \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774\ub2e4. \uac19\uc740 \ud50c\ub7ab\ud3fc\uc740 \ubb3c\ub860\uc774\uace0 10g \ubd80\ud130\ub294 \uc774 \uae30\uc885 \uac04\uc758 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc5d0 \ud65c\uc6a9 \ud560 \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc774\uae30\uc885 \uac04\uc758 TTS\ub294 <span style=\"color:black\">endian format\uc5d0 \ub530\ub77c conversion\uc774 \ud544\uc694\ud560 \uc218 \ub3c4 \uc788\uace0, conversion\uc5c6\uc774 \uac00\ub2a5 \ud558\uae30\ub3c4 \ud558\ub2e4. \uc774 \ubb38\uc11c\ub294 \ub3d9\uc77c\uae30\uc885\uac04\uc758 TTS\uc5d0 \ub300\ud574\uc11c\ub9cc \uc5b8\uae09 \ud55c\ub2e4.<\/span><br \/>\n\t\t<\/span><\/p>\n<p style=\"margin-left: 55pt\">&nbsp;&nbsp;<\/p>\n<p style=\"margin-left: 55pt\"><strong style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 12pt; line-height: 1.5;\">\uc81c\uc57d \uc0ac\ud56d<\/strong><\/p>\n<ul style=\"margin-left: 90pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Source \uc640 Target Database\ub294 \uac19\uc740 character set ,<span style=\"color:black\">national character <\/span>set\uc774 \uc124\uc815\ub418\uc5b4\uc788\uc5b4\uc57c \ud55c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uac19\uc740 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uac00 Target\uc5d0 \uc874\uc7ac\ud558\uba74 \uc548\ub41c\ub2e4. \ud544\uc694\ud558\uba74 \uc791\uc5c5\uc804 rename \uc744 \ud558\uba74 \ub41c\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">underlying objects(such as mviews) or contained objects(such as partitioned tables) \uc758 \uacbd\uc6b0, \uad00\ub828 object\ub4e4\uc774 \ubaa8\ub450 \ud3ec\ud568\ub418\uc5b4\uc57c \ud568<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SYSTEM tablespace \ud639\uc740 SYS \uac00 \uc18c\uc720\ud55c Object\ub97c transport \ud560 \uc218 \uc5c6\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">floating point number(binary_float, binary_double) \uac00 \ud3ec\ud568\ub41c \uacbd\uc6b0, \ubc18\ub4dc\uc2dc expdb\/impdb \ub97c \uc0ac\uc6a9\ud558\uc5ec\uc57c \ud568<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">10gR2 \ubd80\ud130 XMLType \uc9c0\uc6d0\uc774 \ub418\uc9c0\ub9cc, \ubc18\ub4dc\uc2dc exp\/imp \ub97c \uc0ac\uc6a9\ud558\uc5ec\uc57c \ud55c\ub2e4 (data pump \uc0ac\uc6a9\ubd88\uac00\ub2a5)<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">8.0-compatible advanced queues with multiple recipients \ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4<br \/>\n<\/span><\/li>\n<\/ul>\n<p>\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Minimum Compatibility Requirements<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<div style=\"margin-left: 83pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:366px\">\n<col style=\"width:113px\">\n<col style=\"width:117px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td rowspan=\"2\" valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Transport Scenario<\/strong><\/span><\/p>\n<\/td>\n<td colspan=\"2\" valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515\"><strong>Minimum Compatibility Setting<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515\"><strong>Source Database<\/strong><\/span><\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515\"><strong>Target Database<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Databases on the same platform<\/span>&nbsp;<\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">8.0<\/span>&nbsp;<\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">8.0<\/span>&nbsp;<\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 5px\">\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Tablespace with different database block size than the target database<\/span><\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">9.0<\/span>&nbsp;<\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">9.0<\/span>&nbsp;<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Databases on different platforms<\/span>&nbsp;<\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">10.0<\/span>&nbsp;<\/p>\n<\/td>\n<td valign=\"middle\" style=\"padding-top: 3px; padding-left: 3px; padding-bottom: 3px; padding-right: 3px\">\n<p style=\"text-align: center\"><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">10.0<\/span>&nbsp;<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 85pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>DATA Migration\uc744 \uc704\ud55c TTS \uc808\ucc28<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DATA migration\uc740 \ub3d9\uc77c \uae30\uc885\uac04\uc758 Transportable tablespace \uc791\uc5c5\uc774\ubbc0\ub85c <span style=\"color:black\">endian format <\/span>\ub4f1\uc740 \uc0dd\ub7b5.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>\uc804\uccb4 \uc791\uc5c5 \uc808\ucc28 :<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc815\ub9ac\ud558\uc790\uba74, \uc77c\ubc18\uc801\uc73c\ub85c \uc544\ub798\uc640 \uac19\uc740 \uc808\ucc28\uc5d0 \uc758\ud574\uc11c TTS\uac00 \uc774\ub8e8\uc5b4\uc9c4\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<ol style=\"margin-left: 42pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TTS \ub300\uc0c1 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \uc120\uc815<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TTS violation check<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Violation \uc6d0\uc778 \uc81c\uac70<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ud574\ub2f9 Tablespace Read only mode\ub85c \uc804\ud658<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Metadata export<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ud574\ub2f9 datafile\uc744 Target server\uc5d0 Copy<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Metadata import<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ud6c4\uc18d \uc791\uc5c5<\/span><\/li>\n<\/ol>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 55pt\">&nbsp;<span style=\"color: rgb(255, 0, 0);\">&nbsp;<\/span><strong style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 12pt; line-height: 1.5;\"><span style=\"color: rgb(255, 0, 0);\">TTS \uc791\uc5c5 \uad00\ub828 \uc624\ub77c\ud074 \ubb38\uc81c<\/span><\/strong><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"color: rgb(255, 0, 0);\"><br \/>\n&nbsp;<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; color: rgb(255, 0, 0);\">\uc544\ub798\uc640 \uac19\uc740 \uc624\ub77c\ud074 Bug\uc774 \ud655\uc778\ub428.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"color: rgb(255, 0, 0);\"><br \/>\n&nbsp;<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><span style=\"color: rgb(255, 0, 0);\">Bug 5249074 &#8211; EXPDP ERRORS WHEN MANY TRANSPORTABLE TABLESPACES DEFINED<br \/>\n<\/span><\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; color: rgb(255, 0, 0);\">140\uc5ec \uac1c\uc758 Tablespace\uc5d0 \ub300\ud55c metadata export\uc791\uc5c5 \uc2dc \uc5d0\ub7ec \ubc1c\uc0dd. Bug 5249074\ub294 \ub2e4\ub7c9\uc758 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c expdp \ud560\ub54c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 Bug\uc774\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; color: rgb(255, 0, 0);\">\uadf8\ub7ec\ubbc0\ub85c, OM\uc5d0\uc11c\ub294 TTS\ub97c \uc218\ud589\ud558\uae30 \uc804 Source\ucabd Database\uc5d0 \uad00\ub828 \ud328\uce58 \uc801\uc6a9\uc774 \ud544\uc694\ud558\ub2e4.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"color: rgb(255, 0, 0);\"><br \/>\n&nbsp;<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong><span style=\"color: rgb(255, 0, 0);\">BUG 5252501 : IMP-17, ORA-8103 IMPORTING TRANSPORTABLE TABLESPACE<br \/>\n<\/span><\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; color: rgb(255, 0, 0);\">Import \ud558\ub294 \uacfc\uc815\uc5d0\uc11c \ud14c\uc774\ube14 \ud55c \uac1c \uc5d0\ub7ec \ubc1c\uc0dd\ud568. dictionary managed TBS \uc5d0 \uc704\uce58\ud55c segment header \ub0b4\uc758 extent map \uc744 \uace0\uc804\uc801\uc778 \ubc29\uc2dd\uc73c\ub85c fet$ \uc640 uet$ \ub85c \uc7ac\uad6c\uc131\ud558\ub294 \uacfc\uc815\uc5d0\uc11c exception \uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4\uace0 \ud568.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><span style=\"color: rgb(255, 0, 0);\">\ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uad00\ub828 Tablespace\ub97c Dictionary \ubc29\uc2dd\uc5d0\uc11c Locally \ubc29\uc2dd\uc73c\ub85c \ubcc0\uacbd\ud55c \ud6c4 TTS \uc218\ud589.<\/span><br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\">&nbsp;&nbsp;<\/p>\n<p style=\"margin-left: 55pt\"><strong style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 12pt; line-height: 1.5;\"><br \/><\/strong><\/p>\n<p style=\"margin-left: 55pt\"><strong style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 12pt; line-height: 1.5;\">TTS \uc791\uc5c5 \uc808\ucc28<\/strong><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc2e4 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc704\ud55c \uc791\uc5c5 \uc808\ucc28\uc784.<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Source site \uc791\uc5c5<br \/>\n<\/strong><\/span><\/p>\n<p>\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc0ac\uc804 \uc791\uc5c5<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\">\n&nbsp;<\/p>\n<ul>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc0ac\uc804\uc5d0 Bug 5249074\uc5d0 \ub300\ud55c \ud328\uce58 \uc801\uc6a9. \ud328\uce58 \uc801\uc6a9\ud6c4 \uc544\ub798 \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&nbsp; &nbsp; #  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 0.7em;\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&nbsp; #  SQL&gt; @\/oracle1\/oracle\/td\/rdbms\/admin\/prvtbpm.plb<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 70pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 90pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Bug 5252501 \uc5d0\ub7ec fix\ub97c \uc704\ud574 Dictionary Tablespace \ub97c locally \ub85c \ubcc0\ud615.<br \/>\n<\/span><\/li>\n<\/ul>\n<p style=\"margin-left: 6em;\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\uc900\ube44\ub41c \uc2a4\ud06c\ub9bd\ud2b8 @loc_tbs.sql \uc218\ud589 \ub610\ub294 \uc544\ub798 \uc218\ud589.<br \/>\n<\/span><\/p>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; execute sys.dbms_space_admin.tablespace_migrate_to_local(&#8216;TBS001&#8217;);<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; execute sys.dbms_space_admin.tablespace_migrate_to_local(&#8216;TBS194&#8217;);<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 70pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 90pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Expdp\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c Directory \uc0dd\uc131<br \/>\n<\/span><\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; create directory AAA as &#8216;\/oraom\/MIG_NEW&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;  grant read, write on directory AAA to public;<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 70pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ub300\uc0c1 Tablespace \ud655\uc778.&nbsp;: \ud604\uc7ac 145\uac1c<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\">\n&nbsp;<\/p>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">select distinct tablespace_name<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">from dba_segments<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">where owner in (&#8216;TDOPERO&#8217;,<\/span><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; line-height: 1.5;\">&#8216;TDAPPO&#8217;,<\/span><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; line-height: 1.5;\">&#8216;TDREFNPYS1&#8217;,<\/span><span style=\"font-family: '\ub9d1\uc740 \uace0\ub515'; font-size: 10pt; line-height: 1.5;\">&#8216;TDREFWORK&#8217;,<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDSECO&#8217;) or (segment_name=&#8217;ERP_BIZR_SUM&#8217; and segment_type=&#8217;TABLE&#8217;);<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TTS Violation Check<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc900\ube44\ub41c \uc2a4\ud06c\ub9bd\ud2b8 check_tts.sql \uc218\ud589<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 23px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">@check_tts.sql<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><br \/><\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 65px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc0d8\ud50c)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;  exec dbms_tts.transport_set_check(&#8216;BILLTEMP&#8217;&#8230;&#8230;&#8230;..,false,true)&nbsp;;<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TTS Violation \ud655\uc778&nbsp;: \uc544\ub798 \uacb0\uacfc \uc544\ubb34\uac83\ub3c4 \ub098\uc624\uc9c0 \uc54a\uc544\uc57c TTS\ub97c \uc218\ud589 \ud560 \uc218 \uc788\ub2e4.<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc900\ube44\ub41c \uc2a4\ud06c\ub9bd\ud2b8 Show_vio.sql \uc218\ud589 \ub610\ub294 \uc544\ub798 \uc218\ud589.<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; select * from transport_set_violations;<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<ul style=\"margin-left: 75pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TTS Violation \uc744 \uc5c6\uc560\uae30 \uc704\ud55c \uc791\uc5c5 (OM\uc5d0 \ub9de\uac8c Scripts \uc791\uc131\ub428)<br \/>\n<\/span><\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;@alter_part.sql<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;@drop.sql<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;@rebuild.sql<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TTS Violation \uc7ac\uc218\ud589 \ud6c4 \ud655\uc778.<br \/>\n<\/span><\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 23px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">@check_tts.sql<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 65px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ubc29\uc2dd)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;  exec dbms_tts.transport_set_check(&#8216;BILLTEMP&#8217;,false,true)&nbsp;;<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; select * from transport_set_violations;<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 55pt\"><span style=\"font-size:10pt\"><span style=\"font-family:Wingdings\">\u00e0<\/span><span style=\"font-family:\ub9d1\uc740 \uace0\ub515\"> Violation\uc774 \ub098\uc624\uc9c0 \uc54a\uc73c\uba74 \uc815\uc0c1.<br \/>\n<\/span><\/span><\/p>\n<ul style=\"margin-left: 75pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Tablespace Read only \ubaa8\ub4dc\ub85c \ubcc0\uacbd<br \/>\n<\/span><\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 55px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt;@readonly.sql<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 180px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">select &#8216;alter tablespace &#8216;||tablespace_name||&#8217; read only;&#8217;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">from<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">(select distinct tablespace_name<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">from dba_segments<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">where owner in (&#8216;TDOPERO&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDAPPO&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDREFNPYS1&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDREFWORK&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDSECO&#8217;) or (segment_name=&#8217;ERP_BIZR_SUM&#8217; and segment_type=&#8217;TABLE&#8217;))<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<\/span>&nbsp;<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Metadata export \uc218\ud589<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Expdp.sh \uc218\ud589<br \/>\n<\/span><\/p>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">expdp system\/password dumpfile=tts.dmp directory=AAA  transport_full_check=n parfile=parfile.txt EXCLUDE=OBJECT_GRANT,TRIGGER,MATERIALIZED_VIEW,TABLE_STATISTICS,INDEX_STATISTICS,INDEX,MATERIALIZED_VIEW_LOG<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&lt;parfile.txt \uc0d8\ud50c&gt;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 24pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TRANSPORT_TABLESPACES=(BILLTEMP,CSTTEMP&#8230; tbs \uae30\uc220)<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"><strong>Target Site \uc791\uc5c5<br \/>\n<\/strong><\/span><\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\uc0ac\uc804 \uc791\uc5c5<br \/>\n<\/span><\/div>\n<ul>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ud574\ub2f9 Data file\ub4e4 Copy<br \/>\n<\/span><\/li>\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Expdp\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c Directory \uc0dd\uc131<br \/>\n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; create directory MIG as &#8216;\/oraom\/MIG&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; grant read, write on directory MIG to public;<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 90pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Source\uc640 \uac19\uc740 User \uc0dd\uc131<br \/>\n<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">@create_user.sql \uc218\ud589<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ub300\uc0c1 \ub370\uc774\ud130 \ud30c\uc77c \ud655\uc778 \ud6c4 par_imp.txt \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\">\n&nbsp;<\/p>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr style=\"height: 332px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  sqlplus &#8220;\/ as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">#  SQL&gt; select file_name||&#8217;,\\&#8217; from dba_data_files<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">where tablespace_name in (select distinct tablespace_name<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">from dba_segments<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">where owner in (&#8216;TDOPERO&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDAPPO&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDREFNPYS1&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDREFWORK&#8217;,<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8216;TDSECO&#8217;) or (segment_name=&#8217;ERP_BIZR_SUM&#8217; and segment_type=&#8217;TABLE&#8217;)<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">)<br \/>\n<\/span><\/p>\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/<br \/>\n<\/span><\/p>\n<\/td>\n<\/tr>\n<tr style=\"height: 135px\">\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  none; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&lt;Par_imp.txt \ub0b4\uc6a9 \uc0d8\ud50c&gt;<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">transport_datafiles=\/dev\/vx\/rdsk\/ODB015\/D05S20V15,\\<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/dev\/vx\/rdsk\/ODB015\/D05S20V12,\\<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/dev\/vx\/rdsk\/ODB015\/D04S20V09,\\<br \/>\n<\/span><\/p>\n<p style=\"margin-left: 55pt\"><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\/dev\/vx\/rdsk\/ODB015\/D04S20V04<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Metadata import \uc218\ud589&nbsp;: impdp.sh<br \/>\n<\/span><\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">impdp system\/manager dumpfile=tts.dmp logfile=imp.log directory=MIG parfile=par_imp.txt<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 55pt\">\n&nbsp;<\/p>\n<ul style=\"margin-left: 75pt\">\n<li>\n<div><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Cleansing\uc6a9 Tablespace Read write\ubcc0\uacbd<br \/>\n<\/span><\/div>\n<p style=\"margin-left: 7pt\">\n&nbsp;<\/p>\n<\/li>\n<\/ul>\n<div style=\"margin-left: 44pt\">\n<table style=\"border-collapse:collapse\" border=\"0\">\n<colgroup>\n<col style=\"width:633px\"><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"padding-left: 7px; padding-right: 7px; border-top:  solid 0.5pt; border-left:  solid 0.5pt; border-bottom:  solid 0.5pt; border-right:  solid 0.5pt\">\n<p><span style=\"font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">alter tablespace TBS_SUB_HIST_01 read write;<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"margin-left: 82pt\"><span style=\"font-family:\ubc14\ud0d5; font-size:10pt\"><br \/>\n\t\t<\/span>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TTS (Transportable Tablespace) \uac1c\uc694 Transportable Tablespace\uae30\ub2a5\uc740 \uae30\uc874 \ub370\uc774\ud130 \ub85c\ub529 \ubc29\uc2dd\uc774 \uc2e4\uc81c \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud558\uc5ec insert \ud558\ub294 \ubc29\uc2dd\uacfc\ub294 \ub2e4\ub974\uac8c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub2e8\uc704\ub85c \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774\ub2e4. \uac19\uc740 \ud50c\ub7ab\ud3fc\uc740 \ubb3c\ub860\uc774\uace0 10g \ubd80\ud130\ub294 \uc774 \uae30\uc885 \uac04\uc758 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc5d0 \ud65c\uc6a9 \ud560 \uc218 \uc788\ub2e4. \uc774\uae30\uc885 \uac04\uc758 TTS\ub294 endian format\uc5d0 \ub530\ub77c conversion\uc774 \ud544\uc694\ud560 \uc218 \ub3c4 \uc788\uace0, conversion\uc5c6\uc774 \uac00\ub2a5 \ud558\uae30\ub3c4 \ud558\ub2e4. \uc774 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[10],"tags":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/312"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=312"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}