Purpose
You can execute this statement to drop a tablespace.
Limitations and considerations
You can drop a tablespace only when it does not contain any tables.
Privileges
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 types 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 tblspace1.
obclient> DROP TABLESPACE tblspace1;