Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

impdb has an issue (UDI-31626: operation generated ORACLE error 31626)

shabbirJan 20 2016 — edited Jan 20 2016

Hi all,

Can you guys please help me with the below error. Actually i have downloaded an example expdb file from a BI tutorial website and i need to import it into my test instance for some practices. But it has some severe issues with import.

It gives following error:

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

C:\>impdp shabbir/shabbir@xe directory=dmp_dir dumpfile=BISAMPLE.dmp logfile=BISAMPLE.log

Import: Release 11.2.0.2.0 - Production on Wed Jan 20 11:16:48 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

UDI-31626: operation generated ORACLE error 31626

ORA-31626: job does not exist

ORA-39086: cannot retrieve job information

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551

ORA-06512: at line 1

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Below is the logfile generated

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

;;;

Import: Release 11.2.0.2.0 - Production on Wed Jan 20 11:16:48 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

;;;

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

Master table "SHABBIR"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SHABBIR"."SYS_IMPORT_FULL_01":  shabbir/********@xe directory=dmp_dir dumpfile=BISAMPLE.dmp logfile=BISAMPLE.log

ORA-39097: Data Pump job encountered unexpected error -30094

ORA-39065: unexpected master process exception in DISPATCH

ORA-30094: failed to find the time zone data file for version 11 in $ORACLE_HOME/oracore/zoneinfo

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Regards

Shabbir

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2016
Added on Jan 20 2016
2 comments
2,207 views