-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|