expdp转换表空间学习

核心提示：SQL> grant read,write on directory exp_dir to test;Grant succeeded.SQL> grant read,write on directory exp_dir to xysoul;Grant succeeded.导出的命令：expdp test/t

SQL> grant read,write on directory exp_dir to test;

Grant succeeded.

SQL> grant read,write on directory exp_dir to xysoul;

Grant succeeded.
导出的命令：
expdp test/test directory=exp_dir dumpfile=test.dmp logfile=test.log
导入的命令：分区表两个在不同的表空间上，
impdp xysoul/xysoul directory=exp_dir dumpfile=test.dmp remap_schema=test:xysoul remap_tablespace=users:xysoul remap_tablespace=example:xysoul