OracleにDROP TABLESPACEで表領域を削除する

2021年10月28日

構文
DROP TABLESPACE 表領域 INCLUDING CONTENTS;

使用例
1.表領域TABSP1を削除

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS;
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS;
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS;

2.表領域USERTBSPACEをデータファイルごと削除

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS AND DATAFILES;
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS AND DATAFILES;
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS AND DATAFILES;

3.表領域USERTBSPACEをデータファイル・制約ごと削除

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
SQL> DROP TABLESPACE USERTBSPACE INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

 

Oracle

Posted by arkgame