We help IT Professionals succeed at work.

ERROR ORA-01631 MAXEXTENTS

Dotomashkalo
Dotomashkalo asked
on
Today, i have got an error "ORA-01631 max # extents reached in table" and i used the alter table command to increase the maxextents to fix it. But is there any script i can process every day to check it so that i can fix it before this error occurs?
Comment
Watch Question

Commented:
This is an example of a test statement. It will give you a margin of 5 extents.

select segment_name,max(extent_id),min(ut.MAX_EXTENTS)
from user_extents ue, user_tables ut
 where segment_name = table_name
group by segment_name
having max(extent_id) + 5 >  min(ut.MAX_EXTENTS);

Author

Commented:
That's exactly what i want!! Thanks!!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.