ORA-13158

admin

Bug 27178274  ORA-13158 Is Raised When Running Multiple DataPump Jobs In 12.2
Affects:

Product (Component)	Oracle Server  (Rdbms)
Range of versions believed to be affected	(Not specified)
Versions confirmed as being affected	12.2.0.1 (Base Release)
Platforms affected	Generic (all / most platforms affected)

Fixed:

The fix for 27178274 is first included in

19.1.0

Description

The errors: ORA-39374 and ORA-13158 are hit when running multiple DataPumpjobs in 12.2 database .First job always completes successfully while the rest fails or hangs, eventuallyleading to ORA-04036 if the job is not killed.The error ORA-13158 is raised when unloading the statistics.  Rediscovery NotesWhen multiple export jobs are run and one or more error out with below error:ORA-39374: Statistics failed to export. Failing error isORA-13158: Oracle object <SQL_Plan_Directive_ID> does not exist Workaround- Do not run the jobs concurrently, do not specify parallel > 1- Use exclude=statistics- Use previous versions e.g. version=12.1