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

Thread: Automatic Segment Space Management

  1. #1
    Join Date
    Apr 2004
    Posts
    14

    Automatic Segment Space Management

    I had some doubts regarding Oracle 9i new feature - Automatic Segment Space Management.
    I had queried the view dba_tablespaces and found out that for the following tablespaces system, Undotb1 and temp the parameter
    segment space management is set to manual.

    Now my question is can we convert we change the segment space management parameter to auto for the above three tablespaces.

    As per my knowledge we cannot do the same with alter statement.

    Any comments for the same.

    Regards

    Pradipta

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    As per manual (it sure helps to refer):

    Your specification at tablespace creation time of your method for managing
    available space in segments, applies to all segments subsequently created in the
    tablespace. Also, your choice of method cannot be subsequently altered. Only
    permanent, locally managed tablespaces can specify automatic segment-space
    management.

    Nizar

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