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