>>but from where can i get the rowcount after analyzing table.
 
USER_TABLES.NUM_ROWS
 
It seems you are in hurry ;-)... Take a deeper look of manuals....
 
hth,
Rajesh
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh Sharma
Sent: Wednesday, June 13, 2001 1:30 PM
To: Multiple recipients of list ORACLE-L
Subject: rowcount and rowsize..

hi all,
 
i've a c program which calculates the estimated no of blocks required to store a table after reading the table name, row size and row count.
 
i feel to gather these stats i need to analyze tables. the row size can be found at user_tables.ang_row_len.
 
but from where can i get the rowcount after analyzing table.
any help regarding this.
 
i need these 3 stats in a text file. namely
table_name
row_size
rowcount
 
to make them read by the c program and generate an output file.
thanks
 
saurabh
 

Reply via email to