impdp 异常ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"UNDOTBS1"]  处理

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/royjj/article/details/82020652


[oracle@fiona ~]$  impdp lixora/lixora directory=DPDATA1 dumpfile='hcss_kq_test.dmp' remap_schema=hcss_kq_test:lixora  content=metadata_only 

Import: Release 11.2.0.4.0 - Production on Fri Aug 24 15:03:09 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "lixora"."SYS_IMPORT_FULL_11" successfully loaded/unloaded
Starting "lixora"."SYS_IMPORT_FULL_11":  lixora/******** directory=DPDATA1 dumpfile=hcss_kq_test.dmp remap_schema=hcss_kq_test:lixora content=metadata_only 
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"UNDOTBS1"] 
ORA-01403: no data found

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x83ffd7c8     21979  package body SYS.KUPW$WORKER
0x83ffd7c8      9742  package body SYS.KUPW$WORKER
0x83ffd7c8     17950  package body SYS.KUPW$WORKER
0x83ffd7c8      4058  package body SYS.KUPW$WORKER
0x83ffd7c8     10450  package body SYS.KUPW$WORKER
0x83ffd7c8      1824  package body SYS.KUPW$WORKER
0x60cdcc20         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"UNDOTBS1"] 
ORA-01403: no data found

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x83ffd7c8     21979  package body SYS.KUPW$WORKER
0x83ffd7c8      9742  package body SYS.KUPW$WORKER
0x83ffd7c8     17950  package body SYS.KUPW$WORKER
0x83ffd7c8      4058  package body SYS.KUPW$WORKER
0x83ffd7c8     10450  package body SYS.KUPW$WORKER
0x83ffd7c8      1824  package body SYS.KUPW$WORKER
0x60cdcc20         2  anonymous block

Job "lixora"."SYS_IMPORT_FULL_11" stopped due to fatal error at Fri Aug 24 15:05:00 2018 elapsed 0 00:01:30


解决方法

跳过异常的表空间,指定原来的数据表空间;

impdp lixora/lixora directory=DPDATA1 dumpfile='hcss_kq_test.dmp' remap_schema=hcss_kq_test:hcss_jxw_test TABLESPACES=USERS,EICSP_DB

没有更多推荐了,返回首页

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试

关闭