回复 10# tianshizuoyi V9.5的官方文档:The ALTER TABLESPACE statement is used to modify an existing table space inthe following ways:v Add a container to, or drop a container from a DMS table space; that is, a tablespace created with the MANAGED BY DATA...
显示全部回复 10# tianshizuoyi V9.5的官方文档:The ALTER TABLESPACE statement is used to modify an existing table space in
the following ways:
v Add a container to, or drop a container from a DMS table space; that is, a table
space created with the MANAGED BY DATABASE option.
v Modify the size of a container in a DMS table space.
v Add a container to an SMS table space on a database partition that currently has
no containers.
v Modify the PREFETCHSIZE setting for a table space.
v Modify the BUFFERPOOL used for tables in the table space.
v Modify the OVERHEAD setting for a table space.
v Modify the TRANSFERRATE setting for a table space.
v Modify the file system caching policy for a table space.
V9.7的官方文档:
The ALTER TABLESPACE statement is used to modify an existing table space in the following ways:Add a container to, or drop a container from a DMS table space; that is, a table space created with the MANAGED BY DATABASE option.Modify the size of a container in a DMS table space.
Lower the high water mark for a DMS table space through extent movement.Add a container to an SMS table space on a database partition that currently has no containers.Modify the PREFETCHSIZE setting for a table space.Modify the BUFFERPOOL used for tables in the table space.Modify the OVERHEAD setting for a table space.Modify the TRANSFERRATE setting for a table space.Modify the file system caching policy for a table space.Enable or disable auto-resize for a DMS or automatic storage table space.Rebalance a regular or large automatic storage table space.
收起