TABLE/MV/SYNONYM

From: Roger Xu <wellmetus@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 13 Apr 2010 15:52:16 -0500

Hi,

This is Oracle 10g.

SQL> select owner, object_name, object_type
  2  from all_objects where object_name = 'EMPS';

OWNER                          OBJECT_NAME          OBJECT_TYPE
------------------------------ -------------------- -------------------
PUBLIC                         EMPS     SYNONYM
SCOTT                          EMPS     MATERIALIZED VIEW
SCOTT                          EMPS     TABLE

 Having all these with the same name, how do I know what I am accessing?

scott.emps refers to the MV or the table?

Thanks,

Roger Xu

Follow-Ups:
- Re: TABLE/MV/SYNONYM
  - From: Surachart Opun

TABLE/MV/SYNONYM

Other related posts: