When trying to access an object I get the following error:
"ORA-00942 errors table or view does not exist."
This objects exists, and is owned by another users but I should have been given appropriate privileges to access this object. Why am I getting an error?
The object name must be qualified with the owner name
EX: OWNER.TABLENAME and not just TABLENAME
WORKAROUND 1:
Address a table as SCHEMA.OBJ_NAME and not just OBJ_NAME. Objects with the same names can be owned by different users and privileges can be given to similarly name objects. It must be made clear which object is being accessed.
WORKAROUND 2:
Create a synonym under the accessing user's schema that is associated to the object that belongs to another users.
STATUS:
An enhancement request has been submitted to Development for consideration in future release of Toad for Oracle.
This is an Oracle error and requirement, and similar ORA-00942 errors will be experienced if working with the same SQL in SQL Plus.
