Purpose
This statement is used to delete a tablespace.
Limitations and considerations
The tablespace must be empty to be dropped.
Privilege requirements
To execute the DROP TABLESPACE statement, the current user must have the DROP TABLESPACE privilege. For more information about privileges in OceanBase Database, see Privilege classification in Oracle-compatible mode.
Syntax
DROP TABLESPACE tablespace_name;
Parameters
| Parameter | Description |
|---|---|
| tablespace_name | The name of the tablespace to be dropped. |
Examples
Drop the tablespace object tblspace1.
obclient> DROP TABLESPACE tblspace1;