Export Errors EXP-56 ORA-31600 Invalid Input Value 100000001 For Parameter HANDLE In Function SET_FILTER (Doc ID 1470330.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.4 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.

Symptoms

Export fails with below errors:

. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value 100000001 for parameter HANDLE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 1207
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3641
ORA-06512: at "SYS.DBMS_METADATA", line 670
ORA-06512: at line 1
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value 100000001 for parameter HANDLE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 1207
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3641
ORA-06512: at "SYS.DBMS_METADATA", line 670
ORA-06512: at line 1

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