📋Steps in this guide1/1

EXCLUDE/INCLUDE option in expdp

EXCLUDE/INCLUDE option:

oracle configurationintermediate

by OracleDba

14 views

EXCLUDE/INCLUDE option in expdp

Export a schemas DBACLASS, excluding TABLE EMP_TAB and DEPT Exclude few schemas while import: export/Import only TABLE and INDEX ( OBJECT_TYPE)

Code/Command (click line numbers to comment):

EXCLUDE/INCLUDE option:
These two options can be used in both expdp or impdp to exclude or include, particular objects or object_types:
dumpfile=test.dmp
logfile=test1.log
directory=TEST
exclude=TABLE:"IN ('EMP_TAB','DEPT')"
schemas=DBACLASS
dumpfile=test.dmp
logfile=test1.log
directory=TEST
EXCLUDE=SCHEMA:"IN ('WMSYS', 'OUTLN')"
dumpfile=FULL.dmp
logfile=full.log
directory=exp_dir
directory=DBATEST
INCLUDE=TABLE,INDEX

Comments (0)

Please to add comments

No comments yet. Be the first to comment!