Re: datatype sizes

gshell wrote:
>
> Can anyone point me to a manual reference that gives the byte
> requirements for each of the Oracle datatypes. I'm trying to estimate
> the disk space requirements for a database. I've found the "higher
> level" formulas that calculate the files size based on a row of a
> given size. But they show NADA on how to calculate the row size.
> Specifically, I need the size for a DATE and a NUMBER. I assume,
> given that a NUMBER datatype can handle up to 32 significant digits,
> it must be at least 16 bytes. (If I did my math corrrectly. <big ole
> grin>)
>
> Thanks,
>
> Gary Shell

I don't have the manual in front of me here so I'm wing'en this one. Create a sample table and a few rows. Do an analyze on the table. The dba_tables view should now have some info of the average size of a row in your table. The sql ref also documents two functions, "dump" and "vsize". I'm sure one of these will give you the real size of any column.

                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo