Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Err: Deleting data in a linked table is not supported by this ISAM.

JUPSApr 9 2009 — edited Apr 10 2009

Hi,

while deleting the excel data from sql:
SQL> DELETE FROM EMP$@DBLINK2;
DELETE FROM EMP$@DBLINK2
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported
by this ISAM.
ORA-02063: preceding 2 lines from DBLINK2

can any one tell me the workaround how to delete the data in excel file using sql.

regards,
Sreekanth.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2009

Added on Apr 9 2009

#heterogeneous-connectivity

1 comment

3,714 views