expdp report error when export tables
;;;
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- NBU report error 6 when RMAN backupError
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- ituring Error ReportError
- exp tables sh: Syntax error: `(' is not expectedError
- exp/imp expdp/impdp Tables 萬用字元 % 的使用字元
- 1nd round export and import errorExportImportError
- expdp with error: ORA-39125Error
- exp/imp expdp/impdp Tables 萬用字元 % 的使用【Blog 搬家】字元
- ''Sbt Error = 7011, Errno = 959'' Error When Backing Up To TapeError
- Import Error: cannot import name ‘export_saved_modelImportErrorExport
- 有關error 46 encountered when initializing ldmError
- storm 啟動異常 Error when processing eventORMError
- An error has occurred when creating this preference page.Error
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- CJ20N error:Error when processing asset under construction (AuC) for WBS elementErrorStruct
- mysqldump: Got error: 1168 differently defined non-MyISAM LOCK TABLESMySqlGoError
- @EXPORT and @EXPORT_OKExport
- php的錯誤日誌級別 error_report(轉)PHPError
- oracle安裝遇到:CreateFile() error 32 when trying set file timeOracleError
- Dynamics CRM 2016 404 error before any report runsError
- "Error while unpacking program, code LP5. Please report to author."ErrorWhile
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- error: "net.bridge.bridge-nf-call-ip6tables" is an unknown keyError
- ERROR 1577 (HY000): Cannot proceed because system tables used by Event ScheduleError
- dba_tables,dba_all_tables,user_tables,all_tables有什麼區別
- export 和 export default 區別Export
- exportExport
- ERROR 23 (HY000) at line 29963: Out of resources when opening fileError996
- How to resolve ORA-19706 error when select from dblinkError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- JavaScript中的export、export default、exports和module.exports(export、export default、exports使用詳細)JavaScriptExport
- export和export default的區別Export
- export ORACLE_SID=founder exportExportOracle
- Oracle TablesOracle
- Export and import right application or execute import imp-00010 error solveExportImportAPPError
- mysqldump: Error 2013: Lost connection to MySQL server during query when dumpingMySqlErrorServer
- "Failed to create empty document" error message appears when opening the BrightStor ARCserve BackupAIErrorAPP
- import、require 、export、export default、exports、module exportsImportUIExport