I’m running Toad for Oracle 10.1.1.8. I have noticed that when I connect to a Oracle 11i database (220.127.116.11) and tried to view the data from an external table, I get the following message in a popup:
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.
However I don’t have this problem when I tried to do the same thing when I connect to a 10.2.0.4 database.
In both cases I am viewing an external table using data pump access driver. I can read the data in the 11i database external table using other tools such as SQLPlus.
Can anyone explain this behaviour?