Particular Tigger exclude using DBMS_DATAPUMP export in SCHEMA mode, how?

DanielD

Hi,

Is it possible to specify exclude filter for particular object type and name (TRIGGER, name = TRG_CHECK)
when DBMS_DATAPUMP export in SCHEMA mode is used?

If yes, how? (I could not find any examples).

Thanks.

Pavan Kumar

Hi,

Yes, it 's possbile
Go for "DBMS_DATAPUMP.metadata_filter"

tr it I did not checked

Where you can use name expression at table mode as NAME_EXPR as '!=''DEPT'''
or
dbms_datapump.metadata_filter(vhandle,’EXCLUDE_PATH_LIST’,”’TRIGGER”,”GRANT”’);

DBMS_DATAPUMP.metadata_filter( handle => l_dp_handle,
name => 'NAME_EXPR',
value => 'NOT IN (''TRIG_NAME')',
object_type => 'TRIGGER');

- Pavan Kumar N

Pavan Kumar

Hi,

Yes, it 's possbile
Go for "DBMS_DATAPUMP.metadata_filter"

tr it I did not checked

Where you can use name expression at table mode as NAME_EXPR as '!=''DEPT'''
or
dbms_datapump.metadata_filter(vhandle,’EXCLUDE_PATH_LIST’,”’TRIGGER”,”GRANT”’);

DBMS_DATAPUMP.metadata_filter( handle => l_dp_handle,
name => 'NAME_EXPR',
value => 'NOT IN (''TRIG_NAME')',
object_type => 'TRIGGER');

- Pavan Kumar N