ORA-00942 - WHY?

[ErrolDC2]

I'm trying to understand why i get "table or view does not exist" when i execute a select statement against a table in a local production database versus getting the object returned in a development database. The only execption is when I append "USERS." onto the tablename when making the query in the production database. Can someone help me understand what is different about these two databases? Please note, i'm querying this object as the sys user.

Thank in advance.

 

[Turkbear]

Hi,
One has a synonymn set up for that table so that the
fully-qualified name is not needed..


With synonym:
select some_field from table_name;

Without:
select some_field from schema.table_name;






To Paraphrase:"The Help you get is proportional to the Help you give.."