Question: I am running a Data Pump import
(impdp) and I get the following ORA-31623 error:
ORA-31623: a job is not attached to this session
via the specified handle
How do I fix the ORA-31623 error: a job is not attached to
this session via the specified handle?
Data Pump import and export job use queues, streams and java
If we see any job component is invalid (e.g. dbms_java,
queue dictionary scripts not run, rdbms/admin/utlrp.sql not run) we
may see the ORA-31623 error.
The ORA-31623 can also happens if you are not current with
patches (running catupgrd.sql and/or catpatch.sql ), see
MOSC for details.
To troubleshoot the ORA-31623 error, look for entries in
dba_registry where “status=”invalid” and check dba_objects for
object that are granted owned by SYS that are invalid.
If you want to download a pre-tested script check for
invalid objects, see the
The oerr utility provide the solution for the ORA-31623 error, to
use a valid handle name:
job is not attached to this session via the specified handle
Cause: An attempt to
reference a job using a handle which is invalid or no longer valid
for the current session.
Action: Select a handle
corresponding to a valid active job or start a new job.
Also see MOSC
note 308388.1 for details on diagnosing and tracing the ORA-31623
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.