Re: Temp Tablespace Full

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

-- Received on Fri Apr 09 1999 - 13:24:58 CDT