-
Assm
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 ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|