Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_datapump metadata_filter how to exclude tables

Dawna RobertsOct 9 2008 — edited Oct 9 2008
I am using dbms_datapump and need to export several hundred tables but excluding specific tables. When I try to use the following I get the error message ORA-39001: invalid argument value. Is NOT IN a valid expression for NAME_EXPR in dbms_datapump?

Any ideas on how I can exclude this list of tables from my export? Thanks.

dbms_datapump.metadata_filter(
handle=>h1,
name=>'NAME_EXPR',
value => 'NOT IN (''JOB_SCHEDULE'',''TICKET'',''TRANSPORT'',''TRANSPORT_SITE'',''AP'',''AR_DIST'',''AR_LINES'',''BLENDED_GROUP_DESIGN'',''BLENDED_GROUP_DESIGN_DTL'',''GL_INTERFACE'',''INVENTORY_DAILY'',''INVENTORY_YEAR'',''PRODUCT_GROUP'',''PRODUCT_GROUP_XREF'',''PROSPECT_CUSTOMER'',''QUOTE_CENTER_TERMS'',''QUOTE_CONV_EXCEPT'',''QUOTE_CUSTOMER_XREF'',''QUOTE_HDR'',''QUOTE_NOTES'',''QUOTE_PRODUCT_XREF'',''QUOTE_STATUS_DEF'',''QUOTE_TYPE_DEF'',''QUOTE_ZONE_DEF'',''RGI_ERROR_TABLE'',''RGI_STATUS_TABLE'',''STG_CENTER_OPTION_XREF'',''STG_CUSTOMER_OPTION_XREF'',''STG_INVENTORY_DAILY'',''STG_JOB'',''STG_JOB_DETAIL'',''STG_JOB_SCHEDULE'',''STG_JOB_XREF'',''STG_LOCATION_TERMS'',''STG_QUOTE_INFO'',''STG_TRANSPORT'',''STG_TRANSPORT_SITE'',''USER_OPTION_XREF'')');
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2008
Added on Oct 9 2008
1 comment
3,722 views