1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

exclude one table from datapump import using api

Discussion in 'Server Administration and Options' started by ioug, Dec 9, 2010.

  1. ioug

    ioug Active Member

    Messages:
    9
    Likes Received:
    2
    Trophy Points:
    65
    Hi,

    I would like to use dbms_datapump.metadata_filter to prevent a table in the dumpset to be imported. (I want to import everything in the dumpset BUT one table)

    Can anyone show the correct syntax ?

    Tks !
     
  2. ioug

    ioug Active Member

    Messages:
    9
    Likes Received:
    2
    Trophy Points:
    65
    %$"/%&/$&*%?*

    just found it

    Dbms_Datapump.Metadata_Filter(
    handle => h,
    name => 'NAME_EXPR',
    value => '!=''EXCLUDED_TABLE_NAME''',
    object_type => 'TABLE');

    hope this helps !!
     
    Sadik likes this.