Deletes a tablespace.

Syntax

DROP TABLESPACE tablespacename

Description

You can use the DROP TABLESPACE command to delete a tablespace from the system.

Only the owner of a table can drop a table. Before dropping a tablespace, you must empty all database objects in the tablespace. Objects in other databases may still reside in the tablespace even if no objects in the current database are using the tablespace.

Parameters

Parameter Syntax
tablespacename The name of a tablespace.

Examples

Delete the employee_space tablespace from the system:

DROP TABLESPACE employee_space;