Export/Import DataPump: ORA-31604 or ORA-39036 for Filter Name INCLUDE_NAME_EXPR (Doc ID 340961.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 and later
Oracle Server - Standard Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Sep-2012***

Symptoms

You have created a procedure for an Export Data Pump job, e.g. to export the tables SCOTT.EMP and SCOTT.DEPT

The Export/Import Data Pump job that is started with the Metadata API, errors with:

ORA-39001: invalid argument value
ORA-39036: invalid metadata filter name INCLUDE_NAME_EXPR

Or in the logfile, created in Oracle10g Release 1:

ORA-39125: Worker unexpected fatal error in 
KUPW$WORKER.CONFIGURE_METADATA_UNLOAD while calling 
DBMS_METADATA.SET_FILTER [ESTIMATE_PHASE]
ORA-31604: invalid NAME parameter "INCLUDE_NAME_EXPR" for object type 
TABLE_EXPORT in function SET_FILTER
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
1A7C7C64     13460  package body SYS.KUPW$WORKER
1A7C7C64      5810  package body SYS.KUPW$WORKER
1A7C7C64      4630  package body SYS.KUPW$WORKER
1A7C7C64      8090  package body SYS.KUPW$WORKER
1A7C7C64      1569  package body SYS.KUPW$WORKER
1A7C7C64      6325  package body SYS.KUPW$WORKER
1A7C7C64      1208  package body SYS.KUPW$WORKER
1A8B6AB0         2  anonymous block
Job "SCOTT"."JOB1" stopped due to fatal error at 20:29

Or in the logfile, created in Oracle10g Release 2:

ORA-39036: invalid metadata filter name INCLUDE_NAME_EXPR

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms