Home » RDBMS Server » Server Administration » Convert Manual Segment Space Management to Auto. (Oracle 10.2.0.4 Windows 2003 server.)
Convert Manual Segment Space Management to Auto. [message #391329] Wed, 11 March 2009 17:38 Go to next message
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.
Re: Convert Manual Segment Space Management to Auto. [message #391332 is a reply to message #391329] Wed, 11 March 2009 17:49 Go to previous messageGo to next message
BlackSwan
Messages: 25049
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.
Re: Convert Manual Segment Space Management to Auto. [message #391338 is a reply to message #391329] Wed, 11 March 2009 18:13 Go to previous messageGo to next message
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.
Re: Convert Manual Segment Space Management to Auto. [message #391374 is a reply to message #391338] Thu, 12 March 2009 00:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Convert Manual Segment Space Management to Auto. [message #391404 is a reply to message #391329] Thu, 12 March 2009 02:48 Go to previous messageGo to next message
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
Re: Convert Manual Segment Space Management to Auto. [message #391405 is a reply to message #391404] Thu, 12 March 2009 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Convert Manual Segment Space Management to Auto. [message #391408 is a reply to message #391329] Thu, 12 March 2009 03:20 Go to previous message
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
Previous Topic: RMAN Recovery
Next Topic: login problem
Goto Forum:
  


Current Time: Fri Dec 09 11:36:32 CST 2016

Total time taken to generate the page: 0.05449 seconds