Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 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
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 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.