Metadata Filter in Data Pump API

446 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 best solutions below

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