database:oracle:adjust-tablespace-size
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
database:oracle:adjust-tablespace-size [2023/07/04 19:36] – external edit 127.0.0.1 | database:oracle:adjust-tablespace-size [2023/09/01 16:14] (current) – odefta | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Adjust tablespace size to free up space ====== | ====== Adjust tablespace size to free up space ====== | ||
- | ===== Check existing size ===== | + | ===== Check how much space from datafiles are occupied for a specific tablespace ===== |
+ | |||
+ | Replace < | ||
+ | |||
+ | <code sql> | ||
+ | SELECT df.tablespace_name, | ||
+ | FROM dba_data_files df | ||
+ | LEFT JOIN dba_extents e ON df.file_id = e.file_id | ||
+ | WHERE df.tablespace_name='< | ||
+ | GROUP BY df.tablespace_name, | ||
+ | </ | ||
+ | |||
+ | Output: | ||
+ | < | ||
+ | DATA D: | ||
+ | DATA D: | ||
+ | ... | ||
+ | </ | ||
+ | |||
+ | ===== Check existing | ||
<code sql> | <code sql> |
database/oracle/adjust-tablespace-size.txt · Last modified: 2023/09/01 16:14 by odefta