Cannot import data pump export into XE11 - bug?
flaviocOct 28 2011 — edited Nov 3 2011Hi,
I've just installed XE11g on Windows 2008R2 standard server edition and everything went apparently well.
After fixing certain firewall rules I managed to connect to XE from SQL Developer running on a Mac and also to Apex, I could successfully create workspaces and import apex applications without problems.
Then, when I tried to import a dump made from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production by user SYSTEM for a user schema, I am getting the following message in the import.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
A brief web search returned a handful of pages where someone mentions a similar problem on the full blown 11gR2 requiring a patch to be installed and in the following page the user is getting the same error in a similar situation after installing XE11 on Windows 7 :
http://mashuka.dreamwidth.org/6689.html
Given that XE doesn't normally get any patch being unsupported, does this mean that data pump imports are to be avoided forever?
I also tried importing the same export dump as the expected schema user, but in that case I am getting a very informative ORA-01031: insufficient privileges.
Any clues?
Thanks
----
http://oraclequirks.blogspot.com
http://www.yocoya.com