Re: locally and dictionary managed TEMP tablespace
- From: "~Jeff~" <jifjif@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 10 May 2009 11:09:22 +1200
... 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@xxxxxxxxxx>
>
> 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:
