next extent size exceeds free space left
I issued following query:
select a.table_name, a.next_extent, a.tablespace_name
from all_tables a,
(select tablespace_name, max(bytes) as big_chunk
from dba_free_space
group by tablespace_name ) f
where f.tablespace_name = a.tablespace_name
and a.next_extent > f.big_chunk;
Supposedly, if everything is normal, this shall return no rows selected. However, I am getting one row returned with next extent size greater than free space left. This is not an autoextend tablespace. Is the fix as simple as just increase the tablespace size? Is there any other root cause I should be looking into investigating? Please advice.