FreeLists / oracle-l / RE: System Tablespace allocation

[oracle-l] || [Date Prev] [01-2006 Date Index] [Date Next] || [Thread Prev] [01-2006 Thread Index] [Thread Next]

RE: System Tablespace allocation

From: "Goodson, Doris" <DGoodson@xxxxxxxxxxxxxxxx>
To: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
Date: Wed, 4 Jan 2006 12:46:47 -0800

PSTEMP2 is the temporary tablespace.  I just found my problem.  My
temporary tablespace has ran out of space on disk.

Thanks for all your help.

Doris

-----Original Message-----
From: Dennis Williams [mailto:oracledba.williams@xxxxxxxxx] 
Sent: Wednesday, January 04, 2006 12:35 PM
To: Goodson, Doris
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: System Tablespace allocation

Doris,

> 'ORA-1652: unable to extend temp segment by 8091 in tablespace
SYSTEM'.

For the username you are using to run statistics, what is defined as
the TEMPORARY TABLESPACE?

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