Altering table spaces

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.