EXCLUDE/INCLUDE option in expdp - Oracle Database Script. EXCLUDE/INCLUDE OPTION: These two OPTIONS can be used IN BOTH expdp OR impdp TO exclude OR include, particular objects OR object_types: Export a schemas AODBA, EXCLUDING TABLE EMP_TAB AND DEPT dumpfile=test.dmp LOGFILE=test1.log directory=TEST exclude=TABLE:"IN ('EMP_TAB','DEPT')" schemas=AODBA Exclude few schemas WHILE import: dumpfile=test.dmp LOGFILE=test1.log directory=TEST EXCLUDE=SCHEMA:"IN ('WMSYS', 'OUTLN')" export/Import ONLY TABLE AND INDEX (OBJECT_TYPE) dumpfile=FULL.dmp LOGFILE=full.log directory=exp_dir directory=DBATEST INCLUDE=TABLE, INDEX
EXCLUDE/INCLUDE OPTION: These two OPTIONS can be used IN BOTH expdp OR impdp TO exclude OR include, particular objects OR object_types: Export a schemas AODBA, EXCLUDING TABLE EMP_TAB AND DEPT dumpfile=test.dmp LOGFILE=test1.log directory=TEST exclude=TABLE:"IN ('EMP_TAB','DEPT')" schemas=AODBA Exclude few schemas WHILE import: dumpfile=test.dmp LOGFILE=test1.log directory=TEST EXCLUDE=SCHEMA:"IN ('WMSYS', 'OUTLN')" export/Import ONLY TABLE AND INDEX (OBJECT_TYPE) dumpfile=FULL.dmp LOGFILE=full.log directory=exp_dir directory=DBATEST INCLUDE=TABLE, INDEX