max extents [message #7240] |
Thu, 29 May 2003 14:32 |
Denise McMillan
Messages: 23 Registered: May 2003
|
Junior Member |
|
|
I want to increase the value of Max Extents for a few of our tables. How can I make sure that there is enough tabblespace for the increase? Thanks.
|
|
|
Re: max extents [message #7243 is a reply to message #7240] |
Thu, 29 May 2003 21:19 |
ctg
Messages: 146 Registered: July 2002
|
Senior Member |
|
|
to show the total free space (unused/unallocated):
SELECT tablespace_name, sum(bytes)
FROM dba_free_space
WHERE tablespace_name IN ('ts1','ts2',...'tsN')
GROUP BY tablespace_name
to change MAXEXTENTS, you do not need to have the space available because it does not cause the extents to be allocated.
|
|
|
|