1)
Select sum(bytes) from dba_segments where segment_name =;
or
If u need actual blocks used (below the HWM) for that table do the following
SELECT COUNT (DISTINCT SUBSTR(rowid,1,15)) "Used" FROM table_name;
2) Export/Import or MOVE command.
|
Results 1 to 10 of 16
Thread: Table SizeThreaded View
|
Click Here to Expand Forum to Full Width |