ORACLE: DROP TABLESPACE [EN]
top of page
CerebroSQL

Oracle:

DROP TABLESPACE

DROP TABLESPACE tablespace
[ INCLUDING CONTENTS [ {AND | KEEP} DATAFILES ]
[ CASCADE CONSTRAINTS ]
] ;

example

DROP TABLESPACE tbs_01
INCLUDING CONTENTS
CASCADE CONSTRAINTS;

DROP TABLESPACE tbs_02
INCLUDING CONTENTS AND DATAFILES;

bottom of page