RE: Strange output
Date: Tue, 29 Apr 2008 15:38:03 -0400
Might you have two versions of this table someplace?
Connect as sys
Select owner, table_name
Where table_name = 'FAMIS_GURFEED';
Select * from dba_synonyms
Where synonym_name = 'FAMIS_GURFEED';
As a last resort, are you using Fine Grained Access control on this table to limit the result of queries for some reason?
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mir M. Mirhashimali Sent: Tuesday, April 29, 2008 2:42 PM
Subject: Strange output
Database is 10.1.0.5.0 Redhat Linux 64-bit.
any idea what may cause this. When logged in as the schema owner i don't see all rows. but when i login as system i see all rows.
$ sqlplus /nolog
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Apr 29 13:34:00 2008
SQL> connect famis
SQL> select count(*) from famis_gurfeed;
SQL> connect system
SQL> select count(*) from famis.famis_gurfeed;
http://www.freelists.org/webpage/oracle-l Received on Tue Apr 29 2008 - 14:38:03 CDT