CODEWITHSUNDEEP
oracle-databaseoracle11gora-00942
Clomez
Clomez

Reputation: 1522

ORA-00942: table or view does not exist with huge query

is there a possible way to get more accurate error messages from Oracle?

I have this very large query, with many joins ( entity with multiple @oneToMany )

however, i keep getting 

ORA-00942: table or view does not exist

Error.

I have no idea why and i have one by one re-granted what i think is every table in query, yet, this error still persists....

How do i find out where the query is actually failing? i have feeling it isnt even a missing about table...

i cant really share the query, but is there possible other things that can throw the same error?

I can also run SELECT on all the tables in query, tested them one by one..

Upvotes: 0

Views: 554

Answers (1)

Thomas Strub
Thomas Strub

Reputation: 1285

Usually you should get the line of the error: 

SQL> select err from so_59733262;
select err from so_59733262
                *
ERROR at line 1:
ORA-00942: table or view does not exist

and the * points to the last table which is missing.

Upvotes: 0

Related Questions