Database Table Sizing
I am not very knowledgable in this area so would appreciate any advice you guys can give.
I need to provide a projected estimate of Oracle db tables. Essentially my problem is in trying to work out the size of one single row. I have a table which uses the varchar2, integer and date datatypes but I cannot seem to find anywhere how many storage bytes each of these use (with the exception of varchar).
As far as I understand for integers and numbers it depends on the actual number entered - is this correct? If so - is there anyway I can estimate this based on the data I know will be entered.
Also, I read somewhere that date takes 7 bytes of storage - is this correct?
All help much appreicated,
Click Here to Expand Forum to Full Width