Re: Cannot set TEMP offline

Rick Denoire wrote:

> Hello
>
> I have a locally managed TEMP tablespace consisting of two files (8
> and 16 GB). In order to get rid of one of these files, I would set the
> tablespace offline and remove it, but Oracle does not allow me to do
> that. Perhaps I could drop the tablespace while online but I fear that
> this could render the DB unusuable.
>
> "alter tablespace TEMP offline"
> I get ORA-03217 (bad option or something similar)
>
> I can afford to take the DB down to this this if necessary, but I am
> interested in knowing how to do it without downtime anyway.
>
> Oracle 8.1.7 / Solaris 2.7
>
> Any hint?
>

why don't you create another lmt temp tablespace and change user's default temp tablespace to the new one. after a while you should be able to take old temp tablespace offline/drop and recreate them as tempfiles are quicker to create and assign them back.

-- 
hth,
Stan