DROP TABLESPACE

Remove a tablespace.

Syntax:

   DROP TABLESPACE tablespace_name [INCLUDING CONTENTS [AND DATAFILES]
      [CASCADE CONSTRAINTS]];

"I am become death, shatterer of worlds" - Robert J. Oppenheimer (citing from the Bhagavad-Gita, after witnessing the world's first nuclear explosion)

Related Commands:

CREATE TABLESPACE
ALTER TABLESPACE

Related Views:

 DBA_TABLESPACES                           USER_TABLESPACES
 DBA_TS_QUOTAS                             USER_TS_QUOTAS