Database exception due to insufficient disk space on Oracle

Oracle a database exception was caused by insufficient disk space. The size of the data file needs to be reduced to resolve.

1 , check the name and number of the data file

Select File#,name from V$datafile;

2 , see which data file occupies the largest space, according to the data file number to view the maximum number of blocks of data file

Select Max (block_id) from dba_extents where file_id=8;

Query results

3 , and calculates the actual space occupied by the table space. ( not the size of the physical file )

To view the size of each data block

Show parameter db_block_size;

Query results

8192 is that 8k

Calculate the physical space occupied by all data blocks

Select 7680*8/1024 from dual;

result is 60M

so now it's actually used 60M of space. We can change the size of the data file to a reasonable size larger than 60M.

ALTER DATABASE datafile ' D:\APP\ADMINISTRATOR\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_9OWSBMYH_. DBF ' RESIZE 100M;

From for notes (Wiz)

Database exception due to insufficient disk space on Oracle