RE: Strange output

Start by dumping the object data, synonym data, and view text. We have no
way to know what famis_gurfeed is from the data supplied.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mir M. Mirhashimali
Sent: Tuesday, April 29, 2008 2:42 PM
To: oracle-l@xxxxxxxxxxxxx
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
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




--
http://www.freelists.org/webpage/oracle-l


Other related posts: