Re: Cannot set TEMP offline

Hi Rick,

From a discussion on Metalink:

<quote>
Sorry for the delay, this issue slipped past me. These restrictions are only on locally managed TEMPORARY tablespaces. Regular 'locally managed tablespaces' can be taken offline. Actually, you can do everything you would to a locally managed tablespace. The difference is that a TEMPORARY locally managed tablespace's datafile isn't listed in the controlfile at all, where a regular locally managed tablespace is in the controlfile </quote>

Peter

"Rick Denoire" <100.17706_at_germanynet.de> schreef in bericht news:dfkbru4ove988ig6ich6epq0794tf52qn5_at_4ax.com...
> 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?
Received on Wed Oct 23 2002 - 01:55:44 CDT