This content has been marked as final. Show 5 replies
Seems you have taken full export. I suggest you using full=y while import.
Edition and version (full version in five postitions please, not marketing label) of export source database?
Does the impdp session output anything else? What does the last lines from the output log say, other than what's posted above?
What happens if you export and import specific schema only?
Lookup the description for EXCLUDE parameter.
Edited by: orafad on Dec 27, 2011 1:10 PM
the full version string of the export database is 220.127.116.11.0. on Ubuntu 10.04.3 LTS
No the impdp simply does nothing for some two minutes and then breaks with the error message mentioned.
From what I can see, there's no difference at all when trying to import a specific schema only or the full database.
Within the log file, I find the following additional information:
Import: Release 18.104.22.168.0 - Production on Di Dez 27 13:52:23 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Express Edition Release 22.214.171.124.0 - Production
Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_01": /******** AS SYSDBA schemas=KISMON directory=imp_dir dumpfile=exp_full.dmp
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
As I read in another post, I made sure that the files are available in version 14:
SQL> select *
2 from v$timezone_file;
and the file mentioned is available in the folder specified.
Does this help?
thanks for your input, you brought me on the right track: In the installation of Oracle XE 11g, there's a timezone file missing. As a shortcut, I simply copied the existing version 14 files and renamed them to version 11 and all works great.
Seems to be a deployment error in the Oracle XE 11g.
Thanks anyway for your help!
Best regards, Jürgen
Nice work. I thought of something missing, but I couldn't remember what exactly.
The "bug" was reported earlier in this thread, however without mention of 31626/39086 errors:
Edited by: orafad on Dec 27, 2011 2:50 PM