Submitted by: Padmanathan
Hi,
select owner, segment_name,bytes/1024/1024 "Size in Mb" from dba_segments where segment_type=<TABLE_NAME>
This is total size physicall occupied
for actual size:
Analyze the table first using DBMS_STATS package and run the follwoing command.
select table_name, num_rows* avg_row_len from dba_tables where table_name=<TABLE_NAME>
for accurate you can include pctfree parameter also.
Padmanathan
Above answer was rated as good by the following members:
Priyanka84