Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- impdp system/ [password_of_sys] @ [SID] remap_schema=[NAME_OF_SOURCE_SCHEMA]:[NAME_OF_TARGET_SCHEMA] TABLE_EXISTS_ACTION=REPLACE dumpfile=[filename].dmp
- #example
- impdp system/oracle@mydvsid remap_schema=dbschema1source:dbschema1target_COPY TABLE_EXISTS_ACTION=REPLACE dumpfile=dbexport1.dmp
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement