Re: Temp Tablespace Full

From: G.H VITTAL <vittal_at_india.hp.com>
Date: Thu, 08 Apr 1999 12:15:15 +0530
Message-ID: <370C507A.5D30B2A3@india.hp.com>

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 Thu Apr 08 1999 - 01:45:15 CDT