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

For a NUMBER(5), the vsize can be up to 4.
For a NUMBER(10), the vsize can be up to 6.
For a NUMBER(20), vsize can be up to 11.

Try creating columns with your datatypes, put the maximum numeric value in them, and use VSIZE to see the stored byte length.

See http://www.lonyx.com for links to additional tips and answers.

ken k <khkachn_at_toadDIESPAMMER.net> wrote in message news:H%S35.482$BA1.1000118_at_news.abs.net...
> 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 Wed Jun 21 2000 - 00:00:00 CDT