ITPub博客

首页 > 数据库 > Oracle > IMPDP时ORA-39014,ORA-39029,ORA-04031shared memory

IMPDP时ORA-39014,ORA-39029,ORA-04031shared memory

原创 Oracle 作者:darren__chan 时间:2014-11-21 23:50:14 0 删除 编辑

Import: Release 11.2.0.3.0 - Production on Fri Nov 21 12:39:34 2014


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


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TABLE_08" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_08":  system/******** DIRECTORY=D1 dumpfile=hx_gzl.dmp logfile=hx__gzl.log tables=hx_bak.BBFB_GZL_CS_BQGZKZ,hx_bak.BBFB_GZL_CS_BQGZ,hx_bak.BBFB_GZL_CS_GLLCGZ,hx_bak.BBFB_GZL_CS_HDXQGZ,hx_bak.BBFB_GZL_CS_LCSXGZ,hx_bak.BBFB_GZL_CS_SJGZ  table_exists_action=truncate 
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","SELECT /*+all_rows*/ SYS_XML...","SQLA^bfdb9a64","chedef : qcuatc")
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2


ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT /*+all_rows*/ SYS_XML...","SQLA^bfdb9a64","precison::ub1:qctoinpr")
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2


最终解决方法,重启数据库!



来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29863023/viewspace-1342139/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-39151分析
请登录后发表评论 登录
全部评论
一思尚存,此志不懈

注册时间:2014-09-09

  • 博文量
    210
  • 访问量
    1344208