Re: Permanent tablespace to temporary?

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Wed, 26 Aug 1998 09:03:47 -0400
Message-ID: <6s110k$r86$1@client3.news.psi.net>

Hi Juergen,

Drop the rollback segment and then drop the tablespace. Just make sure that you have at least three active rollback segments before you drop it. (I don't remember what horrible things can happen if you have less than two active rollback segments -- but why take any chances.)

regards

Jerry

Juergen Hoffmann wrote in message <35E309A9.4EB1EA8B_at_cube.net>...
>Hi,
>
>Is it possible to change a permanent tablespace to temporary?
>
>I created a tablespace containing one large rollback segment for a
>installation procedure. Unfortunately I forgot to give it the
>"temporary" attribute.
>
>Now I don't need this tablespace anymore. Bringing it offline gives
>Error-Messages in the application that Oracle can't find the rbs.
>Switching it to temperary doesn't work, because Oracle says, that
>the tablepsace contains data and can't be set to temporary.
>
>Is there any way to delete the tablespace without loss of data?
>
>Juergen
>
Received on Wed Aug 26 1998 - 08:03:47 CDT