데이터 펌프 이관 절차 - 스키마, TABLSPACE 변경시_2

[ 3. IMPDP ]
expdp 받은 TABLE 을 impdp 를 진행한다.
조건은 아래와 같다.
RCHWIN 이라는 유저의 특정 TABLE 인 PUMP_TEST  와 그에따른  INDEX 를 RCHWIN_2  의 유저에 이관한다.
단 TABLESPACE 는 TABLE 과 INDEX  모두 TS_TABLE 과 TS_INDEX 에서  TS_PUMP  로 바뀐다. 
 

[TEST] /PUMP_TEST/> cat imp_PUMP_TEST.par "imp_PUMP_TEST.par" 6 줄, 134 자 directory=PUMP_DIR dumpfile=PUMP_TEST.dmp logfile=imp_PUMP_TEST.log REMAP_TABLESPACE=TS_TABLE:TS_PUMP REMAP_TABLESPACE=TS_INDEX:TS_PUMP REMAP_SCHEMA=RCHWIN:RCHWIN_2   [TEST] /PUMP_TEST/> imp system/패스워드 parfile=imp_PUMP_TEST.par LRM-00101: unknown parameter name 'directory' LRM-00113: error when processing file 'imp_PUMP_TEST.par' IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help IMP-00000: Import terminated unsuccessfully [TEST] /PUMP_TEST/> impdp parfile=imp_PUMP_TEST.par Import: Release 10.2.0.3.0 - 64bit Production on Wednesday, 11 March, 2009 11:21:24 Copyright (c) 2003, 2005, Oracle.  All rights reserved. Username: system Password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining Scoring Engine options Master table "SYSTEM"."SYS_IMPORT_FULL_05" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_05":  system/******** parfile=imp_PUMP_TEST.par Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "RCHWIN_2"."PUMP_TEST"       523.4 MB  681097 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

 

[ 4. IMPORT 확인 ]
RCHWIN 계정의 TABLE 및 INDEX 가 RCHWIN_2 로 정상적으로 이관이 되었는지 확인해보고
TABLESPACE 또한 지정한것으로 바뀌었는지 확인해보자.
 
SQL> select owner, segment_name, segment_type, tablespace_name, bytes/1024/1024 from dba_segments
where segment_name='PUMP_TEST';
OWNER       SEGMENT_NAME      SEGMENT_TYPE       TABLESPACE_NAME        BYTES/1024/1024
------------------------------ ---------------------------------------------------------------------------------------
RCHWIN             PUMP_TEST         TABLE              TS_TABLE                                608
RCHWIN_2         PUMP_TEST          TABLE               TS_PUMP                               656
2 rows selected.

 

SQL> select owner, index_name,  tablespace_name from dba_indexes
where table_name='PUMP_TEST';
OWNER                          INDEX_NAME                     TABLESPACE_NAME              
------------------------------ ------------------------------ ------------------------------
RCHWIN                         PUMP_TEST_2IX     TS_INDEX                     
RCHWIN                         PUMP_TEST_PK      TS_INDEX                     
RCHWIN                         PUMP_TEST_1IX     TS_INDEX                     
RCHWIN_2                     PUMP_TEST_2IX     TS_PUMP                    
RCHWIN_2                     PUMP_TEST_PK      TS_PUMP                     
RCHWIN_2                     PUMP_TEST_1IX     TS_PUMP