Re: TEMP tablespace problem

It is temporary. This is not the problem.

But thanks anyway.

Guy Shilo

"Alex Ivascu" <alex_at_ivascu.comNOSPAM> wrote in message news:<F4ex9.22011$bG.14537_at_rwcrnsc53>...
> Make sure that the tablespace type is 'TEMPORARY'.
>
> (select tablespace_name,contents from dba_tablespaces ;)
>
> Alex Ivascu
>
>
>
> "Guy" <ni4ni_at_hotmail.com> wrote in message
> news:d2eb532b.0211030604.444ce2da_at_posting.google.com...
> > Hello
> >
> > Ive been dealing with Oracle for few years now, but havent seen this
> > kind of problem before.
> >
> > When I install a new DB, I usually set a TEMP tablespace with
> > 200-500MB of space. And unless the database has really huge sorts,
> > this works fine.
> > Now I got a DB that was installed by someone else. The TEMP tablespace
> > grows and grows and it seems like it isnt cleaned at all. If I set a
> > size limit (say 500 MB) it eats it up in 2-3 days and then it gets
> > stuck with full tablespace. If I set it to auto-extend it continues to
> > grow and in about a week I end up with a 14 GB tablespace (then I have
> > to recreate it).
> >
> > Does anyone have an idea why this happens ? or any solution ?
> > Doesnt TEMP tablespace supposed to clean unnecessary data ?
Received on Mon Nov 04 2002 - 00:51:23 CST