How to do tables export with several options



How to do tables export.


1- Export more that one table :

expdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=tables.dmp TABLES=employees,jobs,departments

2- Export tables that belong to only tablespaces tbs_4, tbs_5 and tbs_ 

   expdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=tbs.dmp TABLESPACES=tbs_4, tbs_5, tbs_6


3- Exportar tables for different schemas.

expdp user/****** directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log schemas='scott','hr' include=TABLE:\"IN (\'EMP\', \'JOBS\')\"

Comments