Error ORA-31623 On DataPump Export Via DBScheduler After First Run Was Successful
(Doc ID 788301.1)
Last updated on MARCH 29, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 14-sep-2017***
When running an export job in DB console, the job will run one time successfully but the subsequent runs will fail with errors:
ORA-31623: a job is not attached to this session via the specified handle
Execute Failed: ORA-31623: a job is not attached to this session via the
ORA-6512: at "SYS.DBMS_DATAPUMP", line 2315
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3157
ORA-6512: at line 27 (DBD ERROR: OCIStmtExecute)
No export log is created.
This procedure is referenced in
<Note 461307.1> - How To Export Database Using DBConsole/OEM In 10G
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document