Lookup Errors ORA-02019 or ORA-00942 are received if the Schema Name under Object Explorer is changed & a new Editor Window is opened. The query statement that is ran is the same.
ERRORS:
If query is using a DB Link:
Lookup Error - Oracle Database Error: ORA-02019: connection description for remote database not found
Example: SELECT * FROM emp@MAUI_DBLINK3;
If just a regular table query:
Lookup Error - Oracle Database Error: ORA-00942: table or view does not exist
Example: SELECT * FROM Table_Name;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center