Message-Id: <10736.126228@fatcity.com> From: Amar Kumar Padhi Date: Wed, 10 Jan 2001 11:32:55 +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.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@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@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@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@LAZYDBA.com to subscribe send a blank email to oracledba-subscribe@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 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


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@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@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@LAZYDBA.com
to subscribe send a blank email to = oracledba-subscribe@LAZYDBA.com
Visit the list archive: