DROP TABLESPACE
DROP TABLESPACE tablespacename
This statement will drop the named tablespace which must be empty and owned by the invoking user. Tablespace names are case sensitive.
See also: