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

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Wed, 3 Feb 2016 17:14:55 -0400
Message-ID: <CAGYrQyt5qsj-CLpMEkKJ6Pi1wNjzwahc1h-iGm7hknmam69MDg_at_mail.gmail.com>

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/expdp_at_ELWY_3_17 full=Y directory=EXPDP dumpfile=EXPELWY_11G.dmp logfile=expdpELWY.log METRICS=Y exclude=statistics version=11

impdp \" SYS/XACH!DAZA!pass_at_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

2016-02-01 14:51 GMT-04:00 Powell, Mark <mark.powell2_at_hpe.com>:

> 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-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_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
>
>
>

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

Received on Wed Feb 03 2016 - 22:14:55 CET