数据库告警日志报错
ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.
是数据库在收集统计信息时候出现.环境是rac.原因是11g的oracle在访问外部表的时候不支持在dmp格式下以rowid的方式访问.这里数据量不大,把外部表改为堆表后解决.其他方面问题可以参考以下文献.
Get “KUP-04084” error message when viewing an external table in the schema browser’s data tab
说明
I am getting the following error message when trying to view an external table in the schema browser’s data tab.ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.原因
The query the schema browser is running in the background to return the data is asking to also return the ROWID, which is not supported by Oracle for external tables.解决办法
WORKAROUND:
1) Highlight your external table on the left hand side of the schema browser.
2) Select the data tab on the right hand side. (you will get the error)
3) Click OK on the error.
4) Click the ‘View/Edit Query’ button the data tab’s tool bar. The button is the second from the left on the toolbar and looks like a piece of paper with a magnifying glass.
5) Remove ‘ROWID,’ from the statement in the window and click OK.This statement should stay modified until you close the schema browser, so you will need to do this each time you open a new schema browser and want to view your external table. I will let you know what development says once I hear back from them.
其他信息
This is only an issue in Oracle 11gR2 databases.
