Re: locally and dictionary managed TEMP tablespace
- From: Mayen.Shah@xxxxxxxxxx
- To: nileshkum@xxxxxxxxx
- Date: Sat, 9 May 2009 09:04:51 -0400
Since it is temp tablespace why not simply drop and create new one?
"nilesh kumar" <nileshkum@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
May 09 2009 09:00 AM
Please respond to
nileshkum@xxxxxxxxx
To
ORACLE-L <oracle-l@xxxxxxxxxxxxx>
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
Other related posts:
