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: