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 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"
Please reply for solution.. its emergency.