Database Utilities (MOSC)

MOSC Banner

expdp error ora-31600 invalid input value xxx for parameter HANDLE in function SET_FILTER

edited Jun 21, 2018 9:54AM in Database Utilities (MOSC) 4 commentsAnswered
Hello,

I have an expdp job that has started spouting this set of messages:

ORA-31693: Table data object "schema"."table_name" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-31600: invalid input value 307819 for parameter HANDLE in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 555
ORA-06512: at "SYS.DBMS_METADATA", line 2858
ORA-06512: at "SYS.DBMS_METADATA", line 4500
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA",

The message is repeated multiple time with the value in the ora-31600 message increasing by 1 each time.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center