Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rowcount and rowsize..

RE: rowcount and rowsize..

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 13 Jun 2001 02:15:41 -0700
Message-ID: <F001.00327316.20010613021024@fatcity.com>

<FONT color=#0000ff face=Courier

size=2>>>but from where can i get
the rowcount after analyzing table.
 
<SPAN

class=960321909-13062001>USER_TABLES.NUM_ROWS
<SPAN

class=960321909-13062001> 
It
seems you are in hurry ;-)... Take a deeper look of manuals....
<SPAN

class=960321909-13062001> 
<SPAN

class=960321909-13062001>hth,
<SPAN

class=960321909-13062001>Rajesh

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Saurabh SharmaSent:   Wednesday, June 13, 2001 1:30 PMTo: Multiple recipients of list   ORACLE-LSubject: 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.   

   <FONT
  color=#0000ff face=Courier size=2>   

  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
    Received on Wed Jun 13 2001 - 04:15:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US