Re: Strange Error importing a dmp file from Oracle11g to Oracle 12c

Does the target database (Devlp12c) have atemporary tablespace, and does it have files?

select t.tablespace_name, f.file_name
from dba_tablespaces t, dba_temp_files f where t.tablespace_name=f.tablespace_name;

On Thu, Oct 6, 2016 at 1:56 PM, Murray Sobol <Murray.Sobol_at_openlink.com> wrote:

> 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
>
>
>
> The Log file created when doing the EXPDO in Oracle 11g showed no errors.
>
>
>
> Any assistance will be appreciated.
>
> Murray Sobol
>
> Openlink Agribusiness
>
> Email: 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-l