The problem when we use IMPDP

create directory  mydir as 'c:\data' grant read,write on directory mydir  to schemaname;

export: expdp user/pass@db  DIRECTORY=mydirectory schemas=schemaname dumpfile=schemaname.dmp

import:

impdp 'sys/pass@db as sysdba'  directory=DUMP_DIR remap_schema=oldschemaname:newschemaname TRANSFORM=oid:n dumpfile=schemaname.dmp  EXCLUDE=TRIGGER  EXCLUDE=MATERIALIZED_VIEW logfile=schemaname.log

TRANSFORM=oid:n  used for ORA-39083

generate sql script : impdp 'sys/pass@db as sysdba' directory=DUMP_DIR remap_schema=oldschemaname:newschemaname TRANSFORM=oid:n dumpfile=schemaname.dmp sqlfile=script.sql  logfile=schemaname.log

if any error, we can  use sql script do it again. first exclude , then update sql script and execute

转载于:https://www.cnblogs.com/cquccy/p/3420091.html