select bytes
from dba_segments
where segment_name = 'your_table';
divide the result by 1024*1024*1024 and you'll get
the size in GB
- Original Message -
From:
Pillai, Rajesh
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 15, 2003 9:24
PM
Hi!
You have to change the 'next extent' valuefor
the table to make it fit into available free space. Oracle will calculate the
next extent size based on both new value of 'pctincrease= 0' and current
value of 'next extent' which is still 520 MB and there's no chunk that big. I
believe