Oracle 把一个用户的数据导入另一个用户 (数据泵)
导入数据报错:
ORA-31655: no data or metadata objects selected for job ORA-39154: Objects from foreign schemas have been removed from import Master table "TH2321"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
解决方案:
impdp user/password dumpfile=temp.dmp directory=dump remap_tablespace=[old_table_space]:[new_table_space] ; old是指server1机器上的tablespace_name,new是指server2上的