Message-Id: <10736.126229@fatcity.com> From: Amar Kumar Padhi Date: Wed, 10 Jan 2001 11:35:26 +0400 Subject: RE: ORA-1652: unable to extend temp segment by 1065 in tablespace This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07AD7.E631E200 Content-Type: text/plain; charset="iso-8859-1" give it one more try.. check the dba_segments for 'TEMPORARY', check if the output has any other tablespace... select tablespace_name, count(1) from dba_segments where segment_type = 'TEMPORARY' group by segment_type,tablespace_name; Thanks, Amar Kumar Padhi Software Consultant -----Original Message----- From: Weerd Kirsten, E.C. de [mailto:Kirsten.deWeerd@Oranjewoud.nl] Sent: Wednesday, January 10, 2001 11:25 AM To: 'Varsha Savyasachi' Cc: ORACLE Fatcity Mail (E-mail); Oracle LazyDBA Mail (E-mail) Subject: RE: ORA-1652: unable to extend temp segment by 1065 in tablespace TEST ...... ------_=_NextPart_001_01C07AD7.E631E200 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ORA-1652: unable to extend temp segment by 1065 in = tablespace TEST

give it one more try..
check the dba_segments for 'TEMPORARY', check if the = output has any other
tablespace...

select tablespace_name, count(1)
from dba_segments
where segment_type =3D 'TEMPORARY'
group by segment_type,tablespace_name;

Thanks,
Amar Kumar Padhi
Software Consultant

-----Original Message-----
From: Weerd Kirsten, E.C. de [mailto:Kirsten.deWeerd@Ora= njewoud.nl]
Sent: Wednesday, January 10, 2001 11:25 AM
To: 'Varsha Savyasachi'
Cc: ORACLE Fatcity Mail (E-mail); Oracle LazyDBA = Mail (E-mail)
Subject: RE: ORA-1652: unable to extend temp segment = by 1065 in
tablespace TEST

......