Hi,

When I do the query below, there is no value for max_extents for the temporary tablespace. Why is that? Does it mean there could be unlimited number of extents in a temporary sort segment?

Thank you!
-------------------------

SQL>select tablespace_name ts, initial_extent init,
next_extent next, min_extents min, max_extents max
from dba_tablespaces
where tablespace_name = 'TEMP'

TS INIT NEXT MIN MAX
------ ---------- ---------- ---------- ----------
TEMP 65536 65536 1