导出:expdp test/test directory=dump_dir dumpfile=test.dmp logfile=test_expdp.log tables=t
导入表数据:impdp test/test directory=dump_dir dumpfile=test.dmp logfile=impdp_data.log remap_tablespace=system:datatb exclude=index
导入索引数据:impdp test/test directory=dump_dir dumpfile=test.dmp logfile=impdp_index.log remap_tablespace=system:idxtb include=index
查询语句:select segment_name,tablespace_name from dba_segments where owner='TEST';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20750200/viewspace-696584/,如需转载,请注明出处,否则将追究法律责任。