RE: System Tablespace allocation

From: Goodson, Doris <DGoodson_at_SolanoCounty.com>
Date: 2006-01-04 21:46:47
Message-id: F33BF080E9B7F94F98D8F389E09E9598482140@excff01.Solano.Sol

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_at_gmail.com] Sent: Wednesday, January 04, 2006 12:35 PM To: Goodson, Doris
Cc: oracle-l_at_freelists.org
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

Received on Wed Jan 04 2006 - 21:46:47 CST