Re: Resize TEMP tablespace datafile

Tom wrote:

> Hi,
>
> 8.1.5
> Solaris 7
>
> Before anyone says anything yes i know the version is ancient and we are running 9.0.2.4 but this system is due for upgrading in
> April.
>
> One of pur apps did something silly and caused the TEMP tablespace datafile to grow alarmingly. Its normally a couple of hundred meg
> but it grew to 2,5 GIG and i'd like to reduce that size. I tried to coalese the tablespace and then rezise the datafile but it seems
> that the high water mark is preventing me from reducing the size.
>
> I have seen various options available such as dropping the tablespace and recreating it - If this is the option to take would i have
> to have the instance in restricted session? I could do without taking the instance offline but if i have to i will.
>
> thanks for any suggestions
>
> Tom
>
>

Can do with out taking it down - create a new one (and cap it, if you don't like large files, using the maxsize parameter), alter all users to use the new one as temporary ts, and drop the old one, after making sure it's not used by (long-)running transactions

-- 

Regards,
Frank van Bortel