OraFAQ Forum: Server Administration » Convert Manual Segment Space Management to Auto.

Home » RDBMS Server » Server Administration » Convert Manual Segment Space Management to Auto. (Oracle 10.2.0.4 Windows 2003 server.)

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

Convert Manual Segment Space Management to Auto. [message #391329]

Wed, 11 March 2009 17:38

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi Friends,

We have one tablespace in Manual Segment Space Management.

I like to change this to Automatic Segment Space Management to gain more features of this.

How can i achieve this?

Thanks in Advance,
Seenu.

Report message to a moderator

Re: Convert Manual Segment Space Management to Auto. [message #391332 is a reply to message #391329]

Wed, 11 March 2009 17:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can i achieve this?
Create new tablespace with ASSM & move objects out of old tablespace, & then drop old tablespace.

Report message to a moderator

Re: Convert Manual Segment Space Management to Auto. [message #391338 is a reply to message #391329]

Wed, 11 March 2009 18:13

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Thanks for your quick reply.

Segment mode can be changed as you said.

I have googled and found that it can also be done using Enterprise Manager.

Thanks for sharing your comments.

Thanks & Regards,
Seenu.

Report message to a moderator

Re: Convert Manual Segment Space Management to Auto. [message #391374 is a reply to message #391338]

Thu, 12 March 2009 00:11

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I have googled and found that it can also be done using Enterprise Manager.

Which executes what BlackSwan said.
If this is a EM question we will move this topic to EM forum.
Is this an EM question?

Regards
Michel

Report message to a moderator

Re: Convert Manual Segment Space Management to Auto. [message #391404 is a reply to message #391329]

Thu, 12 March 2009 02:48

microsoft_fly
Messages: 5
Registered: March 2009
Location: hz.zj.china

Junior Member

you can convert manal to assm by procedure
dbms_space_admin.tablespace_migrate_to_local

Report message to a moderator

Re: Convert Manual Segment Space Management to Auto. [message #391405 is a reply to message #391404]

Thu, 12 March 2009 03:10

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

microsoft_fly wrote on Thu, 12 March 2009 08:48

you can convert manal to assm by procedure
dbms_space_admin.tablespace_migrate_to_local

This migrate from dictionary managed (DMT) to locally managed tablespace (LMT), NOT from MSSM to ASSM.

Regards
Michel

Report message to a moderator

Re: Convert Manual Segment Space Management to Auto. [message #391408 is a reply to message #391329]

Thu, 12 March 2009 03:20

microsoft_fly
Messages: 5
Registered: March 2009
Location: hz.zj.china

Junior Member

Sorry! I made a mistake just now.
use cmd:alter table table_name tablespace;
or use exp imp

Report message to a moderator

Previous Topic:	RMAN Recovery
Next Topic:	login problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 24 08:20:38 CST 2025