How to exclude all INDEX,GRANT,SYNONYM,CONSTRAINT while exporting data using Oracle Data Pump API (DBMS_DATAPUMP package)?
Asked
Active
Viewed 354 times
1 Answers
0
The command
expdp help=yes
Gives you the options. You might find the "EXCLUDE" option worth looking at.
See http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_legacy.htm#SUTIL962
EXCLUDE=view,package,function,constraint,ref_constraint,grant....
TenG
- 3,843
- 2
- 25
- 42