RE: Strange output
- From: "Seema Ahuja" <sahuja@xxxxxxxxxxxx>
- To: "mhyder@xxxxxxxx" <mhyder@xxxxxxxx>
- Date: Tue, 29 Apr 2008 12:49:08 -0700
When you ran the last two queries, whom were you connected as?
-Seema
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mir M. Mirhashimali
Sent: Tuesday, April 29, 2008 12:42 PM
To: Dennis Williams
Cc: oracle-l@xxxxxxxxxxxxx
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!
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
