Re: Temp Tablespace Full

From: <sokol_at_opsb.ru>
Date: Wed, 08 Apr 1998 20:59:30 -0600
Message-ID: <6gha22$lpv$1@nnrp1.dejanews.com>

alter tablespace TEMP_TABLESPACE_NAME coalesce;

Luck.

In article <01bd62b5$1fc97160$afae1cc4_at_gharidas>, "Gitesh Haridas" <gharidas_at_za01.mck.co.za> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 08 1998 - 21:59:30 CDT