impdp 导入 提示异常如下
C:\Users\Administrator>impdp dsemr/dsemr dumpfile=emr.dmp logfile=emr.log directory=dump_dir
Import: Release 12.1.0.1.0 - Production on 星期五 6月 21 12:59:16 2019
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39002: 操作无效
ORA-39126: 在 KUPW$WORKER.DISPATCH_WORK_ITEMS [SELECT old_value FROM "DSEMR"."SYS_IMPORT_FULL_01" WHERE process_order = :1] 中 Worker 发生意外致命错误
ORA-25153: 临时表空间为空
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 11014
----- PL/SQL Call Stack -----
object line object
handle number name
00007FF6A2D71BE8 26217 package body SYS.KUPW$WORKER
00007FF6A2D71BE8 11041 package body SYS.KUPW$WORKER
00007FF6A2D71BE8 11944 package body SYS.KUPW$WORKER
00007FF6A2D71BE8 2059 package body SYS.KUPW$WORKER
00007FF6A2D79768 2 anonymous block
DUMPER DIRECTORY: NULL
REMOTE LINK: NULL
TABLE EXISTS : APPEND
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: 在 KUPW$WORKER.DISPATCH_WORK_ITEMS [SELECT old_value FROM "DSEMR"."SYS_IMPORT_FULL_01" WHERE process_order = :1] 中 Worker 发生意外致命错误
ORA-25153: 临时表空间为空
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 11014
----- PL/SQL Call Stack -----
object line object
handle number name
00007FF6A2D71BE8 26217 package body SYS.KUPW$WORKER
00007FF6A2D71BE8 11041 package body SYS.KUPW$WORKER
00007FF6A2D71BE8 11944 package body SYS.KUPW$WORKER
00007FF6A2D71BE8 2059 package body SYS.KUPW$WORKER
00007FF6A2D79768 2 anonymous block
DUMPER DIRECTORY: NULL
REMOTE LINK: NULL
TABLE EXISTS : APPEND
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:\Users\Administrator>impdp dsemr/dsemr dumpfile=emr.dmp logfile=emr.log directory=dump_dir exclude=statistics
Import: Release 12.1.0.1.0 - Production on 星期五 6月 21 13:53:21 2019
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-25153: 临时表空间为空
ORA-06512: 在 "SYS.DBMS_LOB", line 724
ORA-06512: 在 "SYS.DBMS_DATAPUMP", line 4515
ORA-06512: 在 line 1
这个错误貌似是oracle 内部的问题 导致
评论
有用 0
SQL> select temporary_tablespace from dba_users where username='DSEMR';
TEMPORARY_TABLESPACE
------------------------------
TEMP
评论 有用 0
仔细看我的回复，你就算把user_temp扩充到32g也没用
因为你DSEMR用户默认的临时表空间是temp
就像你一直往支付宝里存钱，但是你总是使用微信支付，所以钱不存在
评论 有用 0
