Strange output
From: Mir M. Mirhashimali <mhyder_at_rice.edu>
Date: Tue, 29 Apr 2008 13:41:55 -0500
Message-ID: <48176BF3.2030709@rice.edu>
Mir
Date: Tue, 29 Apr 2008 13:41:55 -0500
Message-ID: <48176BF3.2030709@rice.edu>
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
Enter password:
Connected.
SQL> select count(*) from famis_gurfeed;
COUNT(*)
5022
SQL> connect system
Enter password:
Connected.
SQL> select count(*) from famis.famis_gurfeed;
COUNT(*)
59147
Mir
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 29 2008 - 13:41:55 CDT