When i run query in toad data point 4.3 get error ORA-00942: table or view does not exist but the same query work fine in toad for oracle 12 on same PC. any idea why this happening?
Can you give more details?
Are you logging in the exact same way (and to the same database instance) with both products?
If logging onto different databases, even the same username can have different privs, allowing the user to access some objects on one database, but not the other.
Toad solutions never bypass the security that DBAs have set up on the database, so users may be constrained based on their privileges. You may want to check with your DBA for more information.
Did you fully qualify your table or view? IE: select * from schema.object_name? If not, try adding the schema. The Oracle sessions are pointing to a default schema and if you don't fully qualify your table with schema name it will only look where that session schema is pointed.
Thanks, it works now
1 Like
How did u solve it?
Remember to qualify the schema name in your SQL or if you are using Visual Query Builder an are not using fully qualified SQL that you have the correct default schema on your connection.
1 Like
Hello julie
This is the error i have when i connect or try to explorer my shcema
ora-31011 xml parsing failed ora-19202 error occurred in xml processing
Im using toad since 10 years ago its the fisrt time i have this problem
Everything is fine when im using sql or sql developer