Re: Strange output

  • From: "Mir M. Mirhashimali" <mhyder@xxxxxxxx>
  • To: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • Date: Tue, 29 Apr 2008 14:42:29 -0500

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2008