RE: ORA-1652: unable to extend temp segment by 1065 in tablespace

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Wed, 10 Jan 2001 11:32:55 +0400
Message-Id: <10736.126228@fatcity.com>

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.8C3F7460
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

So you're saying that even with the temporary tablespace defined as TEMP (and thus not TEST) it still needs more than the available 10M in tablespace TEMP ?
What is it writing in this tablespace anyway then ???

> -----Original Message-----
> From: Varsha Savyasachi [SMTP:Varshas_at_mascotsystems.com]
> Sent: Wednesday, January 10, 2001 8:16 AM
> To: 'Weerd Kirsten, E.C. de'
> Subject: RE: ORA-1652: unable to extend temp segment by 1065 in
> tablespace TEST
>
> Just go and add a datafile for the TEST tablespace.
>
> > ----------
> > From: Weerd Kirsten, E.C. de[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> >
> > Hi,
> >
> > I have several ORA-1652 errors listed in the alert.log (Different
> > tablespace
> > named though).
> >
> > The thing that puzzles me is that all of our users have the tablespace
> > TEMP
> > defined as temporary tablespace.
> > So what should I be looking at and/or doing.
> >
> > Oracle 7.2.3 on HP-UX 10.20
> >
> > TIA for any help.
> >
> >
> > Greets,
> >
> > Kirsten
>

Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

------_=_NextPart_001_01C07AD7.8C3F7460
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>

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

<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>

Software Consultant

-----Original Message----- From: Weerd Kirsten, E.C. de [<A = HREF=3D"mailto:Kirsten.deWeerd_at_Oranjewoud.nl">mailto:Kirsten.deWeerd_at_Ora= njewoud.nl</A>]

<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)
 Subject: RE: ORA-1652: unable to extend temp segment = by 1065 in

<BR><FONT SIZE=3D2>tablespace TEST</FONT>
</P>
<BR>

So you're saying that even with the temporary = tablespace defined as TEMP
 (and thus not TEST) it still needs more than the = available 10M in tablespace
 TEMP ?
 What is it writing in this tablespace anyway then = ???

> -----Original Message----- > From: Varsha Savyasachi = [SMTP:Varshas_at_mascotsystems.com]
 > Sent: Wednesday, January 10, 2001 8:16 = AM
 > To:   'Weerd Kirsten, E.C. de' > Subject:      RE: = ORA-1652: unable to extend temp segment by 1065 in

<BR><FONT SIZE=3D2>&gt; tablespace TEST</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Just go and add a datafile for the TEST =

tablespace.

<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; ----------</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; From: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weerd =

Kirsten, E.C. de[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]

<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Hi,</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; I have several ORA-1652 errors listed in =

the alert.log (Different

<BR><FONT SIZE=3D2>&gt; &gt; tablespace</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; named though).</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; The thing that puzzles me is that all of =

our users have the tablespace

<BR><FONT SIZE=3D2>&gt; &gt; TEMP</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; defined as temporary tablespace.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; So what should I be looking at and/or =

doing.

<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Oracle 7.2.3 on HP-UX 10.20</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; TIA for any help.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Greets,</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Kirsten</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
</P>

--------
 Think you know someone who can answer the above = question? Forward it to them!
 to unsubscribe, send a blank email to = oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to = oracledba-subscribe_at_LAZYDBA.com 
 Visit the list archive: <A = HREF=3D"http://www.LAZYDBA.com/odbareadmail.pl" = Received on Wed Jan 10 2001 - 01:32:55 CST