To alter a table space using the command line, use the
ALTER TABLESPACE statement.
About this task
Depending on the type of table space, you can do things
such as:
- Increasing the size of the table space by adding additional containers
- Resizing existing containers
- Dropping containers
- Rebalance the table space to start making use of new containers,
or to move data out of dropped containers
- Lower the high water mark for the table space
- Reduce the overall size of the table space.
You can also rename a table space, and switch it from
offline to online mode.