ITPub博客

首页 > Linux操作系统 > Linux操作系统 > expdp report error when export tables

expdp report error when export tables

原创 Linux操作系统 作者:tengrid 时间:2009-05-18 19:02:53 0 删除 编辑

;;;
Export: Release 10.2.0.1.0 - 64bit Production on Friday, 09 February, 2007 11:02:01

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "BOSS"."SYS_EXPORT_TABLE_03":  parfile=exp.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-04031: unable to allocate 64 bytes of shared memory ("shared pool","SELECT /*+rule*/ SYS_XMLGEN(...","sql area","qeeRwo: qeeCreateRwo")
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x1f40d1d78     14916  package body SYS.KUPW$WORKER
0x1f40d1d78      6300  package body SYS.KUPW$WORKER
0x1f40d1d78      9120  package body SYS.KUPW$WORKER
0x1f40d1d78      3873  package body SYS.KUPW$WORKER
0x1f40d1d78      6917  package body SYS.KUPW$WORKER
0x1f40d1d78      1262  package body SYS.KUPW$WORKER
0x1f4347280         2  anonymous block
Job "BOSS"."SYS_EXPORT_TABLE_03" stopped due to fatal error at 11:02:08
~

exp.par文件如下
---------------------------------------

userid=boss/xxx
directory=dump_files1
ESTIMATE_ONLY=y
tables=(
BOSSHEALTHDATA                 ,                
BOSSSELLERBASICINFO            ,
BOSSSELLERDAILYSTAT            ,
BOSSSELLERDEALBYCLASSID        ,
BOSSSELLERDEALDETAIL           ,
BOSSSELLERGROUP                ,
BOSSSELLERGROUPRELATION        ,
BOSSSELLERLEVELCRITERION       ,
BOSSSELLEROLCOMMDETAIL         ,
BOSSSTATSDATA                  ,
T_BOSSREPORT_HISINFO           ,
T_DEAL_CATEGORY                ,
T_DEAL_EXTRA_INFO              ,
T_DEAL_INFO_4_5188STAT         ,
T_DEAL_INFO_4_STAT             ,
T_DEAL_INFO_5188DELETED_ORI    ,
T_FIRST_DEAL_INFO_4_STAT       ,
T_FIRST_TENPAY_INFO_4_STAT
)
FILESIZE=800M
LOGFILE=export_20070209_5.log

$expdp parfile=exp.par



--------------------
在将shared_pool_size由160M改为250M后,重试正常.

为什么expdp需要调用的对像不存在也可以执行成功?
---------------------
SQL> desc DBMS_METADATA.FETCH_XML_CLOB
ERROR:
ORA-04043: object DBMS_METADATA.FETCH_XML_CLOB does not exist

SQL> desc KUPW$WORKER.GET_TABLE_DATA_OBJECTS
ERROR:
ORA-04043: object KUPW$WORKER.GET_TABLE_DATA_OBJECTS does not exist


当指定了ESTIMATE_ONLY=y时,不能同时指定DUMPFILE,否则报错如下
----------------------------
ORA-39201: Dump files are not supported for estimate only jobs

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

请登录后发表评论 登录
全部评论

注册时间:2009-05-18

  • 博文量
    136
  • 访问量
    379085