Strange output
- From: "Mir M. Mirhashimali" <mhyder@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Apr 2008 13:41:55 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
