Metadata Filter in Data Pump API

408 views Asked by At

How to exclude all INDEX,GRANT,SYNONYM,CONSTRAINT while exporting data using Oracle Data Pump API (DBMS_DATAPUMP package)?

1

There are 1 answers

0
TenG On BEST ANSWER

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....