DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: sement space managent is auto

  1. #1
    Join Date
    Apr 2009
    Posts
    54

    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

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by vnktummala View Post
    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?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by vnktummala View Post
    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.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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
  •  


Click Here to Expand Forum to Full Width