top of page
CerebroSQL

DROP TABLESPACE

RDBMS Type: Oracle

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