Re: Table Size

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/08/04
Message-ID: <398ABDA8.1A4B61C1@edcmail.cr.usgs.gov>#1/1

Lots of options exist:

Use the DBMS_SPACE package
Use the VSIZE function along with the AVG function to calculate the average row length, then multiply by the number of rows
ANALYZE the table and query USER_TABLES (or DBA_TABLES)
Export the table with COMPRESS=Y then import the table with SHOW=Y
Just guess. (just kidding)

HTH,
Brian

Cheung Chung Keung wrote:
>
> How can I calculate the size of a table ?
> Thanks
>
> Eddy

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Aug 04 2000 - 00:00:00 CDT