Oracle: drop a tablespace with its contents and datafiles
DROP TABLESPACE command to clean up a test tablespace, including its objects and data files.
After testing Grafana against an Oracle database, you may want to cleanly remove the tablespace created for it.
DROP TABLESPACE GRAFANA
INCLUDING CONTENTS AND DATAFILES;
What the command does
INCLUDING CONTENTSdrops every object (tables, indexes...) stored in the tablespace; without it, the command fails if the tablespace is not empty.AND DATAFILESalso deletes the data files on disk; without it, they must be removed manually.
Notes
- This cannot be undone: double-check the tablespace name before running it.
- Replace
GRAFANAwith the name of the tablespace to drop.