-
sement space managent is auto
Hi all,
can any one tell me the syntax to make a tablespace's segment space mnagement auto which is segement management is *manual* and exent management is *local autoallocate*.
Best regards
-
check out DBMS_SPACE_ADMIN package.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by vnktummala
check out DBMS_SPACE_ADMIN package.
Thanks,
Will you please explain, how to do that - Convert a non-ASSM to ASSM using DBMS_SPACE_ADMIN?
-
DBMS_SPACE_ADMIN package is used to convert DMTS to LMTS.
We can not change segment space management mode of a table space.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by vnktummala
DBMS_SPACE_ADMIN package is used to convert DMTS to LMTS.
We can not change segment space management mode of a table space.
Thanks,
Well, the question is for that.
-
you are right Thomas, I mis-red the question, my mistake and thanks for pointing it.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
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
|