My Oracle Support Banner

UDI-31626: Operation Generated ORACLE Error 31626 (Doc ID 1928501.1)

Last updated on MAY 17, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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= produces a failure on import of the dumpfile into

Import: Release - 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 - 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.773: Tables exists with TSTZ columns
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.