UDI-31626: Operation Generated ORACLE Error 31626
(Doc ID 1928501.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 184.108.40.206 [Release 10.2 to 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Import of a dumpfile created under 12.1 with VERSION=220.127.116.11.0 produces a failure on import of the dumpfile into 18.104.22.168.0.
Import: Release 22.214.171.124.0 - Production on Tue May 31 14:05:37 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-6512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-6512: at line 1
The error is misleading in that it says "job does not exist".
However, adding the TRACE parameter and examining the Master datapump trace file shows a timezone.dat problem.
When rerunning the Data Pump import with TRACE=1FF0300 we can see in the *dm*.trc file the next:
KUPM:11:08:08.777: exp TSTZ version: 18
KUPM:11:08:08.777: imp TSTZ version: 14
KUPM:11:08:08.777: Need to load secondary TSTZ table version 18
KUPM:11:08:08.778: Error detected by MCP
KUPC:11:08:08.779: Before ENQ: Sending Type: 2022 ID:
KUPC:11:08:08.779: DG,KUPC$S_1_20140916110803,MCP, ,3,Y
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn 329273679 lascn 22
KUPM:11:08:08.780: ORA-39097: Data Pump job encountered unexpected error -30094
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