I created some tablespace in oracle 220.127.116.11.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 ?