OraFAQ Forum: Server Administration » Convert locally managed system tablespace to Dictionary managed tablespace

Home » RDBMS Server » Server Administration » Convert locally managed system tablespace to Dictionary managed tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Convert locally managed system tablespace to Dictionary managed tablespace [message #150081]

Tue, 06 December 2005 03:13

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Hi All,

Is it possible to convert a locally managed system tablespace to Dictionary managed system tablespace. If possible , then please provide the steps.

Regards,
reena

Report message to a moderator

Re: Convert locally managed system tablespace to Dictionary managed tablespace [message #150083 is a reply to message #150081]

Tue, 06 December 2005 03:18

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

which version of Oracle you are using???

It was possible in older versions and i believe with Oracle 9.2 (not sure about the version ) even the system tablespace is made LOCALLY MANAGED .

So Oracle 9.2 onwards , you can not.

[BTW: why do you want to do that even when Oracle has desupported this feature ]

[Updated on: Tue, 06 December 2005 03:19]

Report message to a moderator

Re: Convert locally managed system tablespace to Dictionary managed tablespace [message #150170 is a reply to message #150083]

Tue, 06 December 2005 11:43

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Hi Traun,

I want to create a dictionary managed tablespace on my d.b but my system tablespace is locally managed due to which it is not possible. so ,need a workaround if possible. My d.b is version 9.2.

Regards,
reena

Report message to a moderator

Re: Convert locally managed system tablespace to Dictionary managed tablespace [message #150252 is a reply to message #150170]

Tue, 06 December 2005 22:45

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Reena,

From 9.2 onwards you cannot create dictionary managed tablespace becuase even the system tablespace is locally managed.

But, why do you want to do so ?

Regards,
Tarun

Report message to a moderator

Re: Convert locally managed system tablespace to Dictionary managed tablespace [message #150307 is a reply to message #150170]

Wed, 07 December 2005 02:25

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Tarun,

I wanted to test few commands on my test d.b related to dictionary managed tablespace(just like that).Anyways,thanks for your information.

Regards,
reena

Report message to a moderator

Re: Convert locally managed system tablespace to Dictionary managed tablespace [message #150308 is a reply to message #150307]

Wed, 07 December 2005 02:46

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Even when i was learning i tried the same stuff and asked the same question on the same forum.

You can have look here

http://www.orafaq.com/forum/m/126648/72347/#msg_126648

If you really want to then you can test it on some lower version i.e. Oracle 9.1.

Regards,
tarun

Report message to a moderator

Re: Convert locally managed system tablespace to Dictionary managed tablespace [message #150407 is a reply to message #150081]

Wed, 07 December 2005 15:03

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

It is neat the way things come back around.

Report message to a moderator

Previous Topic:	Moving from rollback segemnts to AUM
Next Topic:	superset of WE8MSWINI1252

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 18:08:54 CDT 2025