Database Utilities (MOSC)

MOSC Banner

DBMS_UITILITY package BODY become invalid and IMPDB operation raise error UDI-31623

ENVIRONMENT:

OS: Windows server 2016 x64

DB: Oracle 19.3

Database anomalies observed

PACKAGE BODY DBMS_UNDO_ADV status invalid

PACKAGE BODY DBMS_UTILITY status invalid

DATAPUMP OPERATION

impdp system/password@lptk_pdbSCSA parfile=imp_FULL_OEMREP_db.par

ERROR

UDI-31623: operation generated ORACLE error 31623

ORA-31623: a job is not attached to this session via the specified handle

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747

ORA-06512: at "SYS.KUPV$FT_INT", line 2144

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

ORA-06512: at "SYS.KUPV$FT_INT", line 2081

ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496

ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127

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