How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases
How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases Lets now try to export tables from different schemas in Oracle 10g database on a Linux server. [oracle@localhost ~]$ sqlplus / as sysdba We are assuming that a1 and a2 are 2 schemas with a common table t1 [oracle@sap1]> expdp ‘”/ as sysdba”‘ directory=DATAPUMPDEMO_exp dumpfile=a1-a2_tables logfile=a1-a2_tables tables=A1.T1,A2.T1 Export: Release 10.2.0.4.0 – 64bit Production on Thursday, 23 June, 2013 15:35:01 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Ent...