Return
-
Title
'ORA-00942 Table does not exist', When running a select statement, connected as SYSDBA -
Description
Compiling and running SQL statements when connected as the SYSDBA returns 'ORA-00942 Table does not exist'. Objects can be viewed in the schema broswer but when trying to query any objects, error 'ORA-00942' is returned.
-
Cause
Being connected as a sysdba will on point the user to the SYS schema when trying to query any object in the User schema
-
Resolution
Workaround 1:
Connect as Normal when creating a new session.Workaround 2:
Add the schema name to any object before running the script.