Forum Stats

  • 3,851,462 Users
  • 2,263,981 Discussions
  • 7,904,719 Comments

Discussions

dblink Error ORA-00942: table or view does not exist

Nisarg Oza
Nisarg Oza Member Posts: 9
edited Jul 20, 2016 9:58AM in General Database Discussions

I have updated database from 10g to 11g ...I have update lib64

We have created dblink from oracle to mysql. In mysql my SID is test and have two database testdb and testdb1.

In odbc.ini my default database is testdb. and my dblink name is db_testdb

Now when I am selecting table using . select * from [email protected]_testdb it return values...

but when I am selecting table using select * from [email protected]_testdb it shows error

ORA-00942: table or view does not exist

[MySQL][ODBC 5.1 Driver][mysqld-5.6.10]Table 'testdb.employee' doesn't exist {42S02,NativeErr = 1146}

ORA-02063: preceding 2 lines from db_testdb

00942. 00000 -  "table or view does not exist"

Please reply for solution.. its emergency.

Answers

This discussion has been closed.