Re: table size in bytes

From: Charles Thompson <thompsoc_at_groupwest.ca>
Date: 1995/03/29
Message-ID: <3lcb8r$4om_at_wolfe.wimsey.com>#1/1


There are a few ways. I've used a query like the following :  

select blocks * 512 /* assuming 512-byte block size ... see init.ora */ from dba_tables
where table_name = 'YOUR_TABLE';  

You could also use the num_rows column in dba_tables and multiply the size in bytes per row.  

--  
=-=-=-=-=-=-=-=-= C h a r l e s   T h o m p s o n =-=-=-=-=-=-=-=-= 
=-=-=-=-=-=-=-=        thompsoc_at_groupwest.ca        =-=-=-=-=-=-=-= 
=-=-=-=-=-=-=                   /\                    =-=-=-=-=-=-= 
=-=--==-=-=                     \/                      =-=-=-=-=-= 
Received on Wed Mar 29 1995 - 00:00:00 CEST

Original text of this message