Re: Strange output

SQL> select owner, object_name, object_type from dba_objects where object_name = 'FAMIS_GURFEED';

OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ 
-------------------
PUBLIC                         FAMIS_GURFEED                  SYNONYM
FAMIS                          FAMIS_GURFEED                  TABLE
RICE_FAMIS                     FAMIS_GURFEED                  TABLE

there is a public synonym. but executing the select with schema owner padded display the same result.

SQL> SELECT COUNT(*) FROM famis.FAMIS_GURFEED;

  COUNT(*)

      5022

-- 
Mir


Dennis Williams wrote:


> Mir,

>  

> You might check some possibilities like synonyms, views, etc. Are 

> there two tables with that name?

>  

> Dennis Williams

> !DSPAM:59,481774b6323196954814159! 

--
http://www.freelists.org/webpage/oracle-l