Re: locally and dictionary managed TEMP tablespace

From: ~Jeff~ <jifjif_at_gmail.com>
Date: Sun, 10 May 2009 11:09:22 +1200
Message-ID: <363634910905091609x53271662o6fca71de5a3c5581_at_mail.gmail.com>

... also, don't forget that the SYSTEM tablespace would also need to be a DMT to allow creation of other DMT tablespaces too.

2009/5/10 <Mayen.Shah_at_lazard.com>

>
> Since it is temp tablespace why not simply drop and create new one?
>
>
>
>
>
>
> *"nilesh kumar" <nileshkum_at_gmail.com>*
> Sent by: oracle-l-bounce_at_freelists.org
>
> May 09 2009 09:00 AM Please respond to
> nileshkum_at_gmail.com
>
> To
> ORACLE-L <oracle-l_at_freelists.org> cc
> Subject
> locally and dictionary managed TEMP tablespace
>
>
> Hello DBA's Good Morning,
>
> Hope Everyone is doing good.
> I have gone crazy with a question, I dont have a requirement to do so. Just
> wanna know.
>
> Is it possible to convert a temporary tablespace which is locally managed
> to dictionary managed and vice versa in 10g.
> As per my knowledge we cannot convert a dicitionary managed temp tablespace
> to locally managed using dbms_space_admin package. Since it would require
> the tablespace to be online, read write and permanent one. And also the best
> of all option would be to drop and re create.
> I searched but could'nt get a doc which would explain this.
>
> Thanks
> Khajwania
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat May 09 2009 - 18:09:22 CDT