jueves, 28 de enero de 2016

problems IMPDP in Oracle xe 11g FIXED

After exporting from 12c with expd version=11

I imported in 11g xe 64x successfully only after updating files, I think this is not legal, but I did only to try.

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 11) I had to update i

n the folder C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo
all teh files from the same folder from 12c



2) I had to update all the contents from the folder C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml from an 11g version too.

the command exec dbms_metadata_util.load_stylesheets; must be successful

Import: Release 11.2.0.2.0 - Production on Thu Jan 28 17:21:11 2016

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-39006: internal error
ORA-39213: Metadata processing is not available

and the import was successfully