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