Hi,

Using the below query u can find exactly how much space has been eaten up on the disk by your table:

select bytes from user_segments where segment_name = <table name>;

or by using the following query to know actually how many bytes data is stored in the table

select sum(vsize(col1) + vsize(col2) + vsize(col3) +........+ vsize(coln)) from <table_name>;

eg: to find the number of bytes of data in dept table use the following query

SELECT SUM( VSIZE(deptno) + VSIZE(dname) + VSIZE(loc) ) FROM scott.dept;

Guna Sagar Challa