size of a table

could you please tell me how to find out the SIZE OF A TABLE.(QUERY)

Thanks
Ravi

user the dba_segments view.

can u give me the query to find the size of a table

thanks
ravi

check the dba_tables

Sam

hey guys

u can use this query to find out the size of a table:



select owner||'.'||segment_name Segment_Name
, segment_type "Segment Type"
, sum(bytes)/1024/1024 "Size In MB"
from dba_segments
group by owner||'.'||segment_name
, segment_type;

Ravi

When i try to log into SQLplus, i get logged on with an error to run the PUPBLD script. I have run that script twice already as sys and still get the error message. When i query any table, i get an error that the table or view does not exist. When i query the same views in svrmgr, the statement is processed.Please help explain.

Hi

you run pupbld.sql as SYSTEM not as SYS
The size of a table you need to analyze the table first to get the statistics and query dba_tables

num_rows* avg length (or smth I forgot thisa column name)

querying dba_segments is a wrong choice

http://www.oracle.com/oramag/code/tips2000/Tip1.html