Oracle 把一个用户的数据导入另一个用户 (数据泵)

发布时间 2023-11-21 19:59:23作者: huakai201

导入数据报错:

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上的