Shrink tables in database
Dear All,
I would like to ask regarding to shrink.
Now in my database is nearly out of space, and I do not want to add more datafile right now.
Thus, I would like to ask whether can shrink help this case. However, when I select free space of each datafile, there is very little free space (less that 1GB).
SQL> select sum(bytes)/1024/1024/1024 from dba_free_space where tablespace_name = 'T24DATAXML' and file_id=7;
SUM(BYTES)/1024/1024/1024
-------------------------
.00793457
totally, I have 51 datafiles, but only about 10 datafiles got free space with similar value as abov.
my question is that should I shrink in this case ?
I would like to ask regarding to shrink.
Now in my database is nearly out of space, and I do not want to add more datafile right now.
Thus, I would like to ask whether can shrink help this case. However, when I select free space of each datafile, there is very little free space (less that 1GB).
SQL> select sum(bytes)/1024/1024/1024 from dba_free_space where tablespace_name = 'T24DATAXML' and file_id=7;
SUM(BYTES)/1024/1024/1024
-------------------------
.00793457
totally, I have 51 datafiles, but only about 10 datafiles got free space with similar value as abov.
my question is that should I shrink in this case ?
0