Re: locally and dictionary managed TEMP tablespace

From: <Mayen.Shah_at_lazard.com>
Date: Sat, 9 May 2009 09:04:51 -0400
Message-ID: <OF573EC336.96A7F8FC-ON852575B1.0047CF70-852575B1.0047DB12_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 - 08:04:51 CDT