RE: Odd Temp tablespace error

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Thu, 26 Oct 2000 12:58:22 -0700
Message-Id: <10661.120341@fatcity.com>

Oracle only uses the temporary tablespace for sorting. A temp segment is created in the users default tablespace when doing stuff like rebuilding indexes or doing a create table as command. That is where your issue lies.

-----Original Message-----
From: blair_at_pjm.com [mailto:blair_at_pjm.com] Sent: Thursday, October 26, 2000 1:06 PM To: Multiple recipients of list ORACLE-L Subject: 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. How is this happening? Received on Thu Oct 26 2000 - 14:58:22 CDT