Purpose
This statement is used to drop a tablespace.
Limitations and considerations
The statement can be successfully executed only when the tablespace contains no tables.
Privilege requirements
To execute the DROP TABLESPACE statement, the current user must have the DROP TABLESPACE privilege. For more information about the privileges of OceanBase Database, see Privilege classification in Oracle 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;