Re: Tablespace local management and temporary tablespace

A copy of this was sent to David Xiao <llyx_at_hotmail.com> (if that email address didn't require changing) On Mon, 13 Dec 1999 15:29:45 GMT, you wrote:

>
>
>How to change tablespace T1 from dictionary to local management uniform
>dynamicaly ?

you don't. locally managed tablespaces must be created that way as the header of the tablespace is setup for it.

A locally managed tablespace can be migrated back to a dicationary managed but not the other way.

>For best performance, is it a good idea to set temporary tablespace
>local management uniform?
>

currently, temporary tables cannot use locally managed tablespaces for their allocations so if you plan on using temporary tables AND your temporary tablespaces are locally managed and the users using the temporary tablespace are assigned to these temporary tablespaces -- it'll not work....

So -- maybe yes, maybe no.

>David Xiao

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Dec 13 1999 - 10:09:40 CST