Deletes a tablespace.


DROP TABLESPACE tablespacename


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.


Parameter Syntax
tablespacename The name of a tablespace.


Delete the employee_space tablespace from the system:

DROP TABLESPACE employee_space;