Strange Error importing a dmp file from Oracle11g to Oracle 12c
Date: Thu, 6 Oct 2016 18:56:56 +0000
Message-ID: <DM5PR02MB279548DF3FA9E1745508D4BDF2C70_at_DM5PR02MB2795.namprd02.prod.outlook.com>
I am getting a strange error (to me) when inporting a dmp file from Oracle 11g to oracle 12c. Here is the output:
C:\>impdp system/manager_at_Devlp12c DIRECTORY=impdp_dir DUMPFILE=expdpd19.DMP LOGF ILE=impdpgrain12cunicode.log
Import: Release 12.1.0.1.0 - Production on Thu Oct 6 14:37:46 2016
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
UDI-28011: operation generated ORACLE error 28011 ORA-28011: the account will expire soon; change your password now
Connected to: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [SEL
ECT old_value FROM "SYSTEM"."SYS_IMPORT_FULL_01" WHERE process_order = :1]
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 11014
- PL/SQL Call Stack ----- object line object handle number name 000007FF81400DA0 26217 package body SYS.KUPW$WORKER 000007FF81400DA0 11041 package body SYS.KUPW$WORKER 000007FF81400DA0 11944 package body SYS.KUPW$WORKER 000007FF81400DA0 2059 package body SYS.KUPW$WORKER 000007FF81408A50 2 anonymous block
DUMPER DIRECTORY: NULL
REMOTE LINK: NULL
TABLE EXISTS : SKIP
PARTITION OPTIONS: NONE
PARTITION OPTIONS: NONE
In procedure SEND_MSG. Fatal=0
KUPC$QUEUE.TRANSCEIVE
KUPC$QUEUE.TRANSCEIVE
DBMS_LOB.CREATETEMPORARY v_md_xml_clob
In procedure DETERMINE_FATAL_ERROR
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [SEL
ECT old_value FROM "SYSTEM"."SYS_IMPORT_FULL_01" WHERE process_order = :1]
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 11014
- PL/SQL Call Stack ----- object line object handle number name 000007FF81400DA0 26217 package body SYS.KUPW$WORKER 000007FF81400DA0 11041 package body SYS.KUPW$WORKER 000007FF81400DA0 11944 package body SYS.KUPW$WORKER 000007FF81400DA0 2059 package body SYS.KUPW$WORKER 000007FF81408A50 2 anonymous block
DUMPER DIRECTORY: NULL
REMOTE LINK: NULL
TABLE EXISTS : SKIP
PARTITION OPTIONS: NONE
PARTITION OPTIONS: NONE
In procedure SEND_MSG. Fatal=0
KUPC$QUEUE.TRANSCEIVE
KUPC$QUEUE.TRANSCEIVE
DBMS_LOB.CREATETEMPORARY v_md_xml_clob
In procedure DETERMINE_FATAL_ERROR
C:\>C:\>
The command I am using is:
C:\>impdp system/manager_at_Devlp12c DIRECTORY=impdp_dir DUMPFILE=expdpd19.DMP REMA
P_SCHEMA=GRAIN12CUNICODE:GRAIN12CUNICODE LOGFILE=impdpgrain12cunicode.log
Any assistance will be appreciated.
Murray Sobol
Openlink Agribusiness
Email: murray.sobol_at_openlink.com<mailto:murray.sobol_at_openlink.com>
Except as otherwise expressly agreed in a binding contract, copyright in this message and any attachments remains with OpenLink. It is confidential and may be legally privileged. If this message is not intended for you it must not be read, copied or used by you or disclosed to anyone else. Please advise the sender immediately if you have received this message in error. Although this message and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by OpenLink for any loss or damage in any way arising from its use.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 06 2016 - 20:56:56 CEST