RE: Odd Temp tablespace error

It bombs out this error when one of your user tried to create an index = on
USERS tablespace and there were not enough room... :P

before the index segments got created fully, Oracle marked it as TEMP segment first. Once it is fully created, its status changed from TEMP t= o
INDEX. But if there are not enough space during that process, it will g= ive
out error that it cannot increase the TEMP segment on USERS tablespace.=

Winnie

Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>@fatcity.com = on
10/26/2000 04:20:34 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: RE: Odd Temp tablespace error

Does anyone have USERS as their default tablespace?=A0 One of your lose= rs...I
mean users is trying to create an object within the USERS tablespace an= d
when Oracle tries to create the object, it bombs out.

Regards,
Satar

   -----Original Message-----
   From:=A0=A0 blair_at_pjm.com [SMTP:blair_at_pjm.com]    Sent:=A0=A0 Thursday, October 26, 2000 9:06 PM    To:=A0=A0=A0=A0 Multiple recipients of list ORACLE-L    Subject:=A0=A0=A0=A0=A0=A0=A0 Odd Temp tablespace error

   Oracle 8.0.5

   My alertlog has an occasional entry that says "ORA-01652 Unable to    extend temp
   segment by 192 in tablespace USERS."

   But if I select temporary_tablespace, username from sys.dba_users - = no

   user has
   USERS as its temporary_tablespace.=A0 How is this happening? Received on Thu Oct 26 2000 - 17:33:04 CDT