Oracle Apps DBA
Tuesday, February 4, 2014
Exporting tables from different Schemas using EXPDP
Following command can be used to export a single table from a different schema :
$ expdp directory=DATA_PUMP_DIR dumpfile=expdp_tst.dmp logfile=expdp_tst.log TABLES=SCHEMA.TABLE_NAME,SCHEMA1.TABLE_NAME
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment