Assm

[steeve123]

I created some tablespace in oracle 9.2.0.1.0.

But the segment_space_management was set to manual. Tought is was default auto in 9i. Guess it is like localy manage tablespace in 8i.

Anyways. Is there a way to alter the tablespace to put it to segment space management auto instead of manual?

like alter tablespace or alter datafile?

I dont know the exact syntax if there is a way.

if there is now way to modify.
Then i will create a tablespace. Set it to auto.
And execute alter table move command.
Is that the fastest way ?

[davey23uk]

nope you cannot convert you have to make a new tablespace

[steeve123]

Thanks for the info.

I also notice that the tablespace system is set to manual.

Can the tablespace system be set to auto also?

[steeve123]

is there a package that convert a tablespace to assm??

Or i have to do a script that do alter table move??

[davey23uk]

no you cant convert, you need to create a new one (as said above) and then move objects

[bazza]

Originally posted by steeve123
Thanks for the info.

Can the tablespace system be set to auto also?

yes the system tablespace can be made as an assm tablespace, but this has to be done at database creation.

Bazza

[mdash]

pls refer recent discussion on assm

http://www.dbasupport.com/forums/sho...threadid=47387