Forum Stats

  • 3,770,778 Users
  • 2,253,164 Discussions
  • 7,875,581 Comments

Discussions

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

DanielD
DanielD Member Posts: 119 Blue Ribbon
edited Nov 6, 2008 2:11PM in General Database Discussions
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.
Tagged:

Best Answer

  • Pavan Kumar
    Pavan Kumar Member Posts: 11,904 Gold Crown
    Accepted Answer
    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

Answers

  • Pavan Kumar
    Pavan Kumar Member Posts: 11,904 Gold Crown
    Accepted Answer
    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
This discussion has been closed.