现场实验expdp/impdp从一个用户expdp导出再impdp导入到另一个用户

从一个用户expdp导出再impdp导入到另一个用户

  expdp \'\/ as sysdba\' directory=awr_reports_dir dumpfile=bill_b_package_state_trans.dmp schemas=bill include=table:\"in\(\'b_package_state_trans\'\)\"
 
 
 impdp \'\/ as sysdba\' directory=data_pump_dir dumpfile=bill_b_package_state_trans.dmp remap_schema=bill:hr  remap_table=b_package_state_trans:package_state_trans remap_tablespace=ticket_data07:users ticket_cidx:users table_exists_action=replace exclude=statistics

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31397003/viewspace-2141678/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31397003/viewspace-2141678/