Toad World® Forums

cannot view data in external table


#1

Hi there,

I’m running Toad for Oracle 10.1.1.8. I have noticed that when I connect to a Oracle 11i database (11.2.1.0) 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?

Thanks,
Gloria