Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2016
Added on Jul 20 2016
7 comments
3,480 views