Re: strange SELECT behavior, possibly related to SYSTEM tblspc being full

niz wrote:
> logging into to sqlplus as appowner, in which schema is table
> big_table:
>
> select * from big_table -> no records returned
> select count(*) from big_table -> over a million records
> select field1, field2, field3, etc etc (all fields) from big_table ->
> over a million records
>
> appowener has full permissions on the table.
>
> first time i saw this, the cause was the SYSTEM tablespace being full.

How do you fill up the SYSTEM tablespace unless you are violating Oracle's published rules around using the SYSTEM tablespace?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org