objects reaching max extents SQL QUERY

hi

8.1.7 - linux

OBJECTIVE - to find out the whether the table has reached max extents or not.


is this correct SQL query which will show me current extent & max extent of a table.


select EXTENTS,MAX_EXTENTS from dba_segments where tablespace_name='PRONTOMSP' and segment_name='PRONTO_GATEWAY_SESSION';

EXTENTS MAX_EXTENTS
---------- -----------
88 2147483645

Yes, what you've done is correct.

Your segment's Max Extents are set to unlimited in your case i.e. 2147483645.

You might want to add the OWNER = to be more specific should you have multiple schemas which the same objects. (Although, obviously not in this case)

john

Thanks a lot for the reply