ALTER TABLESPACE tablespace_name RENAME TO tablespace_name [ENGINE [=] engine_name]
This statement can be used to rename an
CREATE TABLESPACE privilege is
required to rename a general tablespace.
ENGINE clause, which specifies the storage
engine used by the tablespace, is deprecated and will be removed
in a future release. The tablespace storage engine is known by the
data dictionary, making the
obsolete. If the storage engine is specified, it must match the
tablespace storage engine defined in the data dictionary.
Exclusive metadata locks are taken on tables that reside in a general tablespace while the tablespace is renamed, which prevents concurrent DDL. Concurrent DML is supported.