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

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 29 Jan 2016 09:07:35 +1000
Message-ID: <56AA9F37.1030203_at_tpg.com.au>

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
>

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

Received on Fri Jan 29 2016 - 00:07:35 CET