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

Home -> Community -> Usenet -> c.d.o.server -> Database sizeing question - so how big is a number anyway?

Database sizeing question - so how big is a number anyway?

From: ken k <khkachn_at_toadDIESPAMMER.net>
Date: 2000/06/20
Message-ID: <H%S35.482$BA1.1000118@news.abs.net>#1/1

Hi all,

  I am trying to come up with some predictions on how much disk space a table and index is going to take. The table has one date field (7 bytes, found that one) and some number(10,0) and number(5,0) fields.
I found the Oracle documentation on how to estimate a table and index size but have not idea how many bytes the number fields will take. The documentation seems to think you are estimating the size of an existing table, which is dumb IMHO. Does anyone know how the size works for number data type?

Thanks,

Ken K Received on Tue Jun 20 2000 - 00:00:00 CDT

Original text of this message

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