Locally Manged Tablespaces [message #179570] |
Wed, 28 June 2006 01:41  |
vishal gupta
Messages: 111 Registered: March 2001
|
Senior Member |
|
|
Hi,
I am working on Oracle 9i and my question is
What is a locally manged Tablespace and how can we change the existing SYSTEM tablespace to locally managed ?
Can we create another SYSTEM tablespace which is locally managed which can co-exist with the dictionary managed SYSTEM tablespace ?
thanks and regards,
vishal
|
|
|
Re: Locally Manged Tablespaces [message #179575 is a reply to message #179570] |
Wed, 28 June 2006 01:49   |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
In the locally managed tablespace we got two catagories
1.auto
2.uniform
we have some restriction in specifying storage parameter,extending the extent will be taken care by oracle
for the second one,while creating table space we sepcify let us say 1mb as the extent size,for the next extent oracle will take another 1mb....
system tablespace should be in dictionary managed! i don't think so you can create one more tablespace like system! because ambiguity occur, you can't have same name like existing tablespace.
|
|
|
Re: Locally Manged Tablespaces [message #179578 is a reply to message #179575] |
Wed, 28 June 2006 01:59   |
vishal gupta
Messages: 111 Registered: March 2001
|
Senior Member |
|
|
Hi Shahnaz,
Thanks for your reply.
Does locally managed means controlled by user and not by oracle itself ?
Also,how to convert existing dictionary managed SYSTEM tablespace to locally managed tablespace ?
Thanks and Regards,
Vishal
|
|
|
|
|
|
|
|
Re: Locally Manged Tablespaces [message #179738 is a reply to message #179570] |
Wed, 28 June 2006 09:34   |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
One more bit of clarification: Yes, you can convert a dictionary managed system tablespace to locally managed. There are procedures for exactly this step. Once you do, you wouldn't convert back.
|
|
|
Re: Locally Manged Tablespaces [message #179831 is a reply to message #179738] |
Wed, 28 June 2006 23:44   |
shahnazurs
Messages: 240 Registered: June 2005 Location: India
|
Senior Member |
|
|
It is not like that,you can do vice versa!
to change temp tablespace from DMT to LMT
exec dbms_space_admin.tablespace_migrate_to_local('TEMP');
to change temp tablespace from LMT to DMT
exec dbms_space_admin.tablespace_migrate_from_local('TEMP');
|
|
|
Re: Locally Manged Tablespaces [message #179872 is a reply to message #179831] |
Thu, 29 June 2006 02:49  |
JSI2001
Messages: 1016 Registered: March 2005 Location: Scotland
|
Senior Member |
|
|
Quote: | It is not like that,you can do vice versa!
|
What do you mean by that?
1. It's not like that? Do you mean that you cannot convert the system tablespace from dmt to lmt? If that is what you mean then you are wrong.
2. Why are you talking about the TEMP tablespace? Until your last post, the TEMP tablespace has never been mentioned in this thread. It is the SYSTEM tablespace that is being talked about.
If you still believe that the SYTEM tablespace cannot be migrated from dmt to local, then please read the documentation (the link is in one of my posts).
Jim
[Updated on: Thu, 29 June 2006 02:50] Report message to a moderator
|
|
|