Database Administration (MOSC)

MOSC Banner

next extent size exceeds free space left

edited Jan 18, 2012 3:13AM in Database Administration (MOSC) 16 commentsAnswered
My environment is oracle version 10.2.0.3 on solaris 10.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center