Топ-100
 

Описания команд доступны в программе CerebroSQL

DROP TABLESPACE

RDBMS Type: Oracle
Topic

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;