Keep it big. You will need it again.
Mark Moody wrote:
>
> Drop the tablespace and recreate a new one! Two statements.
>
> Mark Moody
>
> Gitesh Haridas <gharidas_at_za01.mck.co.za> wrote in article
> <01bd62b5$1fc97160$afae1cc4_at_gharidas>...
> > I have a Temp tablespace of type temporary.
> > I recently had to add additional datafile to allow major joins and sorts
> > to go through.
> >
> > Is there anyway of shrinking a temporary tablespace to reclaim that
> space,
> > after
> > the transaction is completed.
> > I dont understand. The tablespace is of type temporary.
> >
> > Any ideas
> >
Received on Wed Apr 08 1998 - 20:51:01 CDT
