Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
ORA-00942: table or view does not exist while using database link

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....
Answers
-
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.
-
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.
-
check for the credentials / details from tnsnames.ora being used
-
I just requested for answer.
And your answer is your reply...You are free in OTN community..
-
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.
-
-
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.