database:oracle:drop-tablespace
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
database:oracle:drop-tablespace [2023/03/09 15:37] – created odefta | database:oracle:drop-tablespace [2023/07/04 19:36] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Completely drop the tablespace and the associated data files ====== | + | ====== Completely drop a tablespace and all the associated data files ====== |
+ | |||
+ | ===== Check data files location | ||
First, note all the datafiles associated with your tablespace: | First, note all the datafiles associated with your tablespace: | ||
Line 14: | Line 16: | ||
Result: | Result: | ||
- | < | + | |
{{: | {{: | ||
+ | |||
+ | The ST_SERVERLOG tablespace has 2 data files: | ||
+ | * / | ||
+ | * / | ||
+ | |||
+ | ===== Remove tablespace ===== | ||
+ | |||
+ | <code sql> | ||
+ | DROP TABLESPACE ST_SERVERLOG including contents; | ||
</ | </ | ||
+ | |||
+ | < | ||
+ | This will not remove the data files from the disk, so the space will remain occupied. | ||
+ | </ | ||
+ | |||
+ | ===== Drop data files ===== | ||
+ | |||
+ | Manually go on the disk and remove the associated data files. | ||
+ | If those files are not in use by any tablespace, the Oracle will let you remove them. | ||
- | DROP TABLESPACE USER_WORK including contents; | ||
| | ||
database/oracle/drop-tablespace.1678369074.txt.gz · Last modified: 2023/07/04 19:36 (external edit)