Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BIGFILE tablespace running out of space

Aaron L.Oct 21 2022

I have a tablespace with less than 1% space left. It is a BIGFILE. I was going to run the following command, but I wanted to see if y'all had any advice about what I should do first.

select file_name
,round(sum(bytes) / 1048576) TotalSpace
from dba_data_files 
where tablespace_name = 'MY_DATA'
group by file_name;


+DATA/DB/A58F/DATAFILE/my_data.1111
134545


alter database datafile '+DATA/DB/A58F/DATAFILE/my_data.1111' resize 150G

Will this disrupt or hurt anything?

This post has been answered by Solomon Yakobson on Oct 21 2022

Jump to Answer

Added on Oct 21 2022

#general-database-discussions

5 comments

1,735 views