Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> strange SELECT behavior when SYSTEM tablespace is full

strange SELECT behavior when SYSTEM tablespace is full

From: niz <niz_at_infidel.freeserve.co.uk>
Date: Wed, 18 Jul 2007 16:59:22 -0700
Message-ID: <1184803162.189722.245420@j4g2000prf.googlegroups.com>


when the 2GB SYSTEM tablespace is 100% full, SELECT begins to behave unusually:

logging in with the schema-owner:

select count(*) from BMF -> 8000 row.
select * from BMF -> 0 rows
select field1, field2 from BMF -> 8000 rows select field3 from BMF -> 0 rows
select field4, field 5 from BMF -> 8000 rows select field, field2, field3, field4, field5 from BMF -> 8000 rows

for some reason it stops liking field3

logging in with sys gives the correct results though:

select count(*) from BMF -> 8000 row.
select * from BMF -> 8000 rows
select field1, field2 from BMF -> 8000 rows select field3 from BMF -> 8000 rows
select field4, field 5 from BMF -> 8000 rows select field, field2, field3, field4, field5 from BMF -> 8000 rows

and it also works when the SYSTEM tablespace is increased by 200MB.

there are no column-level privileges in use here. its oracle 9.2.0.5.0 production.

why do SELECT statements require SYSTEM tablespace, and why doesnt oracle give an error instead of suddenly losing columns? is it a known oracle bug? is there a case# for this?

thanks.

--
reply to group - email invalid
Received on Wed Jul 18 2007 - 18:59:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US