-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|