Re: Strange output

In talking with Mir, I realized that he is not only using Banner from SunGard, but also FAMIS (another product), both of which we use. Curious, anyone else on this list in that camp? I know a couple of you use Banner, and I am always interested to meet fellow Banner sufferers. *grin*

On Tue, Apr 29, 2008 at 1:41 PM, Mir M. Mirhashimali <mhyder_at_rice.edu> wrote:

> 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
>
>
>

-- 
Charles Schultz

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