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.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
This is only an issue in Oracle 11gR2 databases.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center