No. 9 ORACLE 10G DATAPUMP REMAP_TABLESPACE ½ºÅ©¸³Æ®
KOVA
2016-11-04
2280
½Ã³ª¸®¿À : TEST DB¿¡ DATAPUMP¸¦ ÀÌ¿ëÇÏ¿© HR, SH À¯Àú¸¦ Å×ÀÌºí½ºÆäÀ̽º¸¦ º¯°æÇÏ¿© À̰ü 1. Å×À̺í, Å×ÀÌºí½ºÆäÀ̽º üũ ½ºÅ©¸³Æ® : chk_tab_list.sql select owner, table_name, tablespace_name as ts_part_name, 'T' as table_type from all_tables where tablespace_name is not null and owner in ('HR','SH') union all select owner, table_name, def_tablespace_name as ts_part_name, 'P' as table_type from all_part_tables where owner in ('HR','SH') order by owner, table_name, ts_part_name; 2. TEST¼¹ö HR, SH °èÁ¤ »ý¼º ¹× ±ÇÇÑ ºÎ¿© SQL> create user hr identified by hr; SQL> create user sh identified by sh; SQL> grant connect, resource to hr,sh; 3. ±âÁ¸¼¹ö Á¢¼Ó ¹× Å×À̺í, Å×ÀÌºí½ºÆäÀ̽º È®ÀÎ SQL> @chk_tab_list.sql 4. ±âÁ¸¼¹ö HR, SH EXPDP ÁøÇà OS> expdp system/oracle dumpfile=hr_sh.dmp logfile=hr_sh.dmp schemas=hr,sh 5. .DMP ´ýÇÁÆÄÀÏ COPY WINSCP, SCPµî TEST¼¹ö·Î ´ýÇÁÆÄÀÏ COPY 6. TEST¼¹ö HR, SH Å×ÀÌºí ½ºÆäÀ̽º º¯°æ ÀÓÆ÷Æ® ÁøÇà OS> impdp system/oracle dumpfile=hr_sh.dmp full=y remap_tablespace=EXAMPLE:KIGOOK 7. µ¥ÀÌÅÍ È®ÀÎ SQL> @chk_tab_list.sql À¯Æ©ºê ¿µ»ó : ORACLE 10G DATAPUMP REMAP_TABLESPACE °Á À¯Æ©ºê ÁÖ¼Ò : https://www.youtube.com/watch?v=wrWZmAT20Q4