REMAP_SCHEMAPObjects from one schema are loaded into another schema.
CREATE OR REPLACE DIRECTORY test_dir AS 'c:\expdp';
GRANT READ, WRITE ON DIRECTORY test_dir TO test;
GRANT READ, WRITE ON DIRECTORY test_dir TO test1;
expdp test/test directory=test_dir dumpfile=test.dmp logfile=imp.log
impdp system/system directory=test_dir repmap_schema=test:test1 dumpfile=test.dmp logfile=imp.log
这里需要注意的是repmap_schema=RESOURCE:TARGET
REMAP_TABLESPACETablespace object are remapped to another tablespace.
expdp system/system directory=test_dir tablespaces=users dumpfile=tablespace.dmp logfile=tlog.log
impdp system/system directory=test_dir remap_tablespace=zhang:users dumpfile=tablespace.dmp logfile=timp.log
实验完成.这个实验可以方便的帮助DBA将一个用户下的所有对象转移为另外一个用户,可以将一个表空间内的内容转移到另外一个表空间.
