Re: Temp Tablespace Full

I would do an alter database datafile resize 100m; but I was under the impression that shrink was just for rbs's. glen

Vitaliy Mogilevskiy wrote:
>
> SHRINK ? - I have never seen such a command !
> anyone else ?
>
> +--------------------------------------------------------------------------+
> | Vitaliy Mogilevskiy
> | Senior Consultant
> | CORE Technology Group, Inc.
> | E-mail: vit100gain_at_earthlink.net
> | Web Page: http://home.earthlink.net/~vit100gain/index.html
> | *** Free DBA Script Library at my Web Page ***
> +--------------------------------------------------------------------------+
>
> "G.H VITTAL" wrote:
>
> > If you give optimal size for the tablespace it should automatically shrink
> > when it exceeds the shrink value.
> >
> > Alternatively you can give the sql command
> >
> > ALTER TABLESPACE ts_name shrink to 10MB which will shrink the tablespace to
> > 10MB. If you don't specify the size as 10MB it will shrink to the optimal
> > value
> >
> > thank you
> > vittal gh
> >
> > Gitesh Haridas wrote:
> >
> > > 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
>
> --

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Fri Apr 09 1999 - 14:12:00 CDT