Is legal to copy files to xe to get impdp working, in this two cases?

[Juan Carlos Reyes Pacheco]

I got two errors when trying to import using impdp from 12c to 11g xe 64x


I'm sure not, but asking anyway.
Thank you :)

I copy files only to try and it work
1) from 11g standard
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml

2) from 12g standard
C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo

and it worked.

the errors was


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


SQL> exec dbms_metadata_util.load_stylesheets;
BEGIN dbms_metadata_util.load_stylesheets; END;

*
ERROR at line 1:
ORA-31609: error loading file "kualter.xsl" from file system directory
"C:\oraclexe\app\oracle\product\11.2.0\server/rdbms/xml/xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 2397
ORA-06512: at line 1

[De DBA]

Not sure about "legal", but the xml stylesheets file is a plain-text
file and can be copied between environments without problems. I've
copied them before, I believe between a 10g an 11g XE installations.
Sometimes Oracle seems to forget to package them.. It may be that
earlier versions lack improvements, though.

Cheers,
Tony

Post by Juan Carlos Reyes Pacheco
I got two errors when trying to import using impdp from 12c to 11g xe 64x
I'm sure not, but asking anyway.
Thank you :)
I copy files only to try and it work
1) from 11g standard
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml
2) from 12g standard
C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo
and it worked.
the errors was
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
SQL> exec dbms_metadata_util.load_stylesheets;
BEGIN dbms_metadata_util.load_stylesheets; END;
*
ORA-31609: error loading file "kualter.xsl" from file system directory
"C:\oraclexe\app\oracle\product\11.2.0\server/rdbms/xml/xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 2397
ORA-06512: at line 1

--
http://www.freelists.org/webpage/oracle-l

[Powell, Mark]

You do not state in your post that you used the 11g expdp utility to make the export file which would be a requirement to export from a higher version to a lower version. Can you confirm that you in fact did do this?


From: oracle-l-***@freelists.org [mailto:oracle-l-***@freelists.org] On Behalf Of Juan Carlos Reyes Pacheco
Sent: Thursday, January 28, 2016 5:38 PM
To: ORACLE-L
Subject: Is legal to copy files to xe to get impdp working, in this two cases?

I got two errors when trying to import using impdp from 12c to 11g xe 64x


I'm sure not, but asking anyway.
Thank you :)

I copy files only to try and it work
1) from 11g standard
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml

2) from 12g standard
C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo

and it worked.

the errors was


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


SQL> exec dbms_metadata_util.load_stylesheets;
BEGIN dbms_metadata_util.load_stylesheets; END;

*
ERROR at line 1:
ORA-31609: error loading file "kualter.xsl" from file system directory
"C:\oraclexe\app\oracle\product\11.2.0\server/rdbms/xml/xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 2397
ORA-06512: at line 1

[Juan Carlos Reyes Pacheco]

Hello Mark, I exported from 12c 64x using expdp to xe11g 64x
I couldn't import, so I executed
exec dbms_metadata_util.load_stylesheets;

Then I updated the files to this directories
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml
C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo

executed succesfully the
exec dbms_metadata_util.load_stylesheets;
and i can import I include the commands

from 12c
SET NLS_DATE_FORMAT=YYYY/MM/DD HH24:MI:SS
C:\app\jreyes\product\12.1.0.1.13\dbhome_1\bin\expdp
expdpadmin/***@ELWY_3_17 full=Y directory=EXPDP dumpfile=EXPELWY_11G.dmp
logfile=expdpELWY.log METRICS=Y exclude=statistics version=11


impdp \" SYS/XACH!DAZA!***@XACH as sysdba \" EXCLUDE=SCHEMA:\"IN
(\'PERFSTAT\',\'SYSMAN\',\'APPQOSSYS\', \'CTXSYS\', \'DBSNMP\',
\'ORACLE_OCM\', \'ORDDATA\', \'ORDPLUGINS\', \'ORDSYS\', \'OUTLN\',
\'PUBLIC\', \'SI_INFORMTN_SCHEMA\', \'SYS\', \'SYSTEM\', \'WMSYS\',
\'XDB\')\" full=Y PARALLEL=1 CLUSTER=N directory=EXPDP
dumpfile=EXPELWY_11G.DMP logfile=impdpXACH.log

Post by Powell, Mark
You do not state in your post that you used the 11g expdp utility to make
the export file which would be a requirement to export from a higher
version to a lower version. Can you confirm that you in fact did do this?
*Sent:* Thursday, January 28, 2016 5:38 PM
*To:* ORACLE-L
*Subject:* Is legal to copy files to xe to get impdp working, in this two
cases?
I got two errors when trying to import using impdp from 12c to 11g xe 64x
I'm sure not, but asking anyway.
Thank you :)
I copy files only to try and it work
1) from 11g standard
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\xml
2) from 12g standard
C:\oraclexe\app\oracle\product\11.2.0\server\oracore\zoneinfo
and it worked.
the errors was
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
SQL> exec dbms_metadata_util.load_stylesheets;
BEGIN dbms_metadata_util.load_stylesheets; END;
*
ORA-31609: error loading file "kualter.xsl" from file system directory
"C:\oraclexe\app\oracle\product\11.2.0\server/rdbms/xml/xsl"
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 2397
ORA-06512: at line 1