Re: Changing the status of temporary tablespace to permanent

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 1 Jun 2001 11:27:11 +0100
Message-ID: <991391301.22946.0.nnrp-13.c30bdde2@news.demon.co.uk>

In my experience, it will also have the effect of dropping the existing temporary segments first (ie, in effect, flushing the SYS-owned temporary segments). This is a (probably inadvisable) way to clear out the tablespace, switch it to permanent and then straight back to temporary.

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B172DE0.72E03B1D_at_exesolutions.com...
> Dark Lord wrote:
>
> > Hi,
> > Quick basic question, if such a thing exists :) Suppose I change the
> > status of my temporary tablespace ( temp) to permanent. What are the
likely
> > results of my action ? Thanks
> >
> > --
> > Silent Running
>
> It will fill up with "temp" tables and crash.
>
> Daniel A. Morgan
>
Received on Fri Jun 01 2001 - 05:27:11 CDT