Re: Temp Tablespace Full

From: Mark Moody <mcmoody_at_no.spam.wcc.com>
Date: 8 Apr 1998 18:52:55 GMT
Message-ID: <01bd6320$2ed4e750$6332cf90@den3970x>

Drop the tablespace and recreate a new one! Two statements.

Mark Moody

Gitesh Haridas <gharidas_at_za01.mck.co.za> wrote in article <01bd62b5$1fc97160$afae1cc4_at_gharidas>...
> 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 Wed Apr 08 1998 - 13:52:55 CDT