DROP TABLESPACE

Purpose

You can use this statement to delete a tablespace logical object. The deletion can only be successful when there are no tables within the tablespace.

Syntax

DROP TABLESPACE tablespace_name;

Parameters

Examples

Delete the tablespace object tablespace001.

DROP TABLESPACE tablespace001;