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,
Received on Wed Jan 10 2001 - 01:24:44 CST
