Advertisement
javapapo

impdb oracle import

Jan 13th, 2013
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.29 KB | None | 0 0
  1. impdp system/ [password_of_sys] @ [SID]  remap_schema=[NAME_OF_SOURCE_SCHEMA]:[NAME_OF_TARGET_SCHEMA] TABLE_EXISTS_ACTION=REPLACE dumpfile=[filename].dmp
  2.  
  3. #example
  4.  
  5. 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