Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to convert tablepace from temporary to permanent?

Re: Is it possible to convert tablepace from temporary to permanent?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 25 Sep 2003 13:57:14 GMT
Message-ID: <_uCcb.122722$bo1.121618@news-server.bigpond.net.au>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3F72E619.584B5C2_at_remove_spam.peasland.com...

> I have to echo Niall's comments. Why?!?!?!?! What is in this temporary
> tablespace that you wish to make "permanent"? Anything in this
> tablespace, by definition, is temporary. So if you want a permanent
> tablespace, just make one!
>

Hi Brian,

You create a tablespace and "accidentally" include the temporary clause ...

Happens all the time ;)

Richard Received on Thu Sep 25 2003 - 08:57:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US