transportable_tablespace

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

transportable_tablespace

Arsalan

Salam Arslan
have a nice day,

I used transportable tablespace from oracle 11.2.0.4 to oracle 12c

while i try to export i face below error please guide me.

expdp system/pass directory=backup full=y dumpfile=EXP1.dmp transportable=always vers
ion=12 logfile=EXP1.log
-------------------------------------------------------------------------------------------------------------
. . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS"           0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES"               0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS"             0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"          0 KB       0 rows
. . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES"             0 KB       0 rows
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows

ORA-39097: Data Pump job encountered unexpected error -920
ORA-39065: unexpected master process exception in DISPATCH
ORA-00920: invalid relational operator

:NOTE I used transportable tablespace to migrate and upgrade from oracle 11g to 12c

please guide me.
Reply | Threaded
Open this post in threaded view
|

Re: transportable_tablespace

ErmanArslansOracleBlog
Administrator
Hi,

Apply patch 17583185 and retry.

Ref:

11.2.0.4 Bug 17583185 - TRANSPORTABLE DATABASE EXPORTING 11G DB FAILS WITH ORA-39097 AND ORA-920 (not a public bug), fixed in 12.1.0.2 and 12.2.0.1