Forum Stats

  • 3,770,740 Users
  • 2,253,161 Discussions
  • 7,875,572 Comments

Discussions

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

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

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 [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"

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

Tagged:
AndrewSayerJohn StegemanSmohib

Answers

  • John Stegeman
    John Stegeman Member Posts: 24,269 Blue Diamond
    edited Jul 20, 2016 8:09AM
    Please reply its urgent...

    You just committed a cardinal sin of assuming your question is so urgent that the massed throngs of people on the OTN community are going to drop whatever they are doing and respond with solutions.

    Whereas what will happen is you will get snarky replies like this one.

    AndrewSayer
  • AndrewSayer
    AndrewSayer Member Posts: 12,998 Gold Crown
    edited Jul 20, 2016 8:13AM
    Nisarg Oza wrote:
    
    ...
    
    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....
    

    Revert back to 10g?

    If you believe it's a bug then you need to file it with MOS.

  • Smohib
    Smohib Member Posts: 217 Blue Ribbon
    edited Jul 20, 2016 8:17AM

    check for the credentials / details from tnsnames.ora being used

  • Nisarg Oza
    Nisarg Oza Member Posts: 9
    edited Jul 20, 2016 8:23AM

    I just requested for answer.

    And your answer is your reply...You are free in OTN community..

  • EdStevens
    EdStevens Member Posts: 28,536 Gold Crown
    edited Jul 20, 2016 8:23AM
    Smohib wrote:
    
    check for the credentials / details from tnsnames.ora being used
    

    tnsnames has nothing to do with credentials.

    And the OP has already established that he is using the same db_link, which means he is pointing to the same database.

    Now, credentials/privs are worth checking, but tnsnames has nothing to do with it.

    John StegemanSmohib
  • EdStevens
    EdStevens Member Posts: 28,536 Gold Crown
    edited Jul 20, 2016 8:26AM
  • John Stegeman
    John Stegeman Member Posts: 24,269 Blue Diamond
    edited Jul 20, 2016 8:28AM

    You're also free to read the FAQ:

    Especially the part that says:

     Never, EVER, mark your subject as "URGENT" or "ASAP".  This forum is manned by volunteers giving their own time to help and your question is never urgent or more important than their own work or than other people's questions. It may be urgent to you, but that's not forum members issue.  By marking your question as urgent you are actually less likely to get a good response, as members will choose to ignore such questions or respond infavorably.
    
This discussion has been closed.