calculate size of idx
- From: "Kommareddy, Srinivas (MED, Wissen Infotech)" <Srinivas.Kommareddy@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 Feb 2004 22:36:03 -0600
Hi Lists,
We are going to perform a data load to a table.
To calculate the space required for n rows for a table we use
avg_row_len*n rows from dba_tables.
But how we can do that for indexes ?
B'coz my table has 7 indexes which are built on 10 different columns. I
want to add space to index tablespace also... (most of the indexes
columns are NUMBER, should I take 32 bytes * n rows to calculate the
size )
Thanks and Regards,
Srinivas
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
