Re: Temp Tablespace Full

From: Frank Heijmans <someone_at_somewhere.nl>
Date: Thu, 15 Apr 1999 15:12:04 GMT
Message-ID: <37160186.32437597@news.xs4all.nl>

On Thu, 08 Apr 1999 12:15:15 +0530, "G.H VITTAL" <vittal_at_india.hp.com> 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

Unfortunately shrink is not an option for tablespaces. just for rbs

regards

Frank
F.Heijmans at delphi dot nl
>
>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 15 1999 - 10:12:04 CDT