Skip to Main Content

ORA-00942: table or view does not exist while using database link

Nisarg OzaJul 20 2016 — edited Jul 20 2016

I have upgrade database from 10g to 11g ..

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

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

Now when I am selecting table using . select * from testdb.demo@db_testdb it return values...

but when I am selecting table using select * from testdb1.employee@db_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"

Why It shows error like testdb.employee, where I am selecting testdb1.employee.

Same thing also working properly in 10g. In 11g it is not working...

Any solution to fix it. or any alternate solution in oracle 11g to connect multiple schema or database of mysql  through database link...

Please reply its urgent....

Comments
Post Details
Added on Jul 20 2016
7 comments
3,104 views