RE: Strange output

From: Seema Ahuja <sahuja_at_ucmerced.edu>
Date: Tue, 29 Apr 2008 12:49:08 -0700
Message-ID: <20080429124908524.00000002520@SAHUJA-LAP1>


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
Received on Tue Apr 29 2008 - 14:49:08 CDT

Original text of this message