Exporting tables from different Schemas using EXPDP – Revisited – version 11gR2

More than an year ago i had written https://aprakash.wordpress.com/2010/10/19/exporting-tables-from-different-schemas-using-expdp/ where in mentioned how to export tables from different schemas using the EXPDP in 10gR2. Using exp - "D:\>exp file= exp_test.dmp log=exp_test.log tables='scott.emp','hr.jobs' feedback=10" Using expdp D:\>expdp directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log schemas='scott','hr' include=TABLE:\"IN (\'EMP\', \'JOBS\')\" With the above expdp command the problem arises when tables with same … Continue reading Exporting tables from different Schemas using EXPDP – Revisited – version 11gR2