RE: Strange output

When you ran the last two queries, whom were you connected as?

-Seema 

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mir M. Mirhashimali Sent: Tuesday, April 29, 2008 12:42 PM
To: Dennis Williams
Cc: oracle-l_at_freelists.org
Subject: 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



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