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 ?