| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: ORA-1652: unable to extend temp segment by 1065 in =
tablespace TEST</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>give it one more try..</FONT>
<BR><FONT SIZE=3D2>check the dba_segments for 'TEMPORARY', check if the =
output has any other</FONT>
<BR><FONT SIZE=3D2>tablespace...</FONT>
</P>
<P><FONT SIZE=3D2>select tablespace_name, count(1)</FONT>
<BR><FONT SIZE=3D2>from dba_segments</FONT>
<BR><FONT SIZE=3D2>where segment_type =3D 'TEMPORARY'</FONT>
<BR><FONT SIZE=3D2>group by segment_type,tablespace_name;</FONT>
</P>
<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Amar Kumar Padhi</FONT>
<BR><FONT SIZE=3D2>Software Consultant</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Weerd Kirsten, E.C. de [<A =
HREF=3D"mailto:Kirsten.deWeerd_at_Oranjewoud.nl">mailto:Kirsten.deWeerd_at_Ora=
njewoud.nl</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, January 10, 2001 11:25 AM</FONT>
<BR><FONT SIZE=3D2>To: 'Varsha Savyasachi'</FONT>
<BR><FONT SIZE=3D2>Cc: ORACLE Fatcity Mail (E-mail); Oracle LazyDBA =
Mail (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: RE: ORA-1652: unable to extend temp segment =
by 1065 in</FONT>
<BR><FONT SIZE=3D2>tablespace TEST</FONT>
</P>
<P><FONT SIZE=3D2>......</FONT>
Received on Wed Jan 10 2001 - 01:35:26 CST
 |
 |