User Tools

Site Tools


database:oracle:adjust-tablespace-size

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revisionBoth sides next revision
database:oracle:adjust-tablespace-size [2019/04/23 18:16] – created odeftadatabase:oracle:adjust-tablespace-size [2019/04/23 18:20] odefta
Line 1: Line 1:
 ====== Adjust tablespace size to free up space ====== ====== Adjust tablespace size to free up space ======
  
-Check existing size:+===== Check existing size ===== 
 <code sql> <code sql>
  select a.file_name,round(a.bytes/1024/1024) totalsize,b.freesize  select a.file_name,round(a.bytes/1024/1024) totalsize,b.freesize
Line 16: Line 17:
 /home/user/app/user/oradata/userorcl/pdborcl/USER_LOB_WORK.DBF 256     247 /home/user/app/user/oradata/userorcl/pdborcl/USER_LOB_WORK.DBF 256     247
 </code> </code>
 +
 +===== Free up space =====
 +
 +<code sql>
 +ALTER DATABASE DATAFILE '/home/user/app/user/oradata/userorcl/pdborcl/USER_DATA_WORK.DBF' RESIZE 50K
 +</code>
 +
database/oracle/adjust-tablespace-size.txt · Last modified: 2023/09/01 16:14 by odefta