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....