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

  • From: De DBA <dedba@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Jan 2016 09:07:35 +1000

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

On 29/01/2016 8:38 am, Juan Carlos Reyes Pacheco wrote:

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


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


Other related posts: