I have a project to estimate the table space size for future additions, This is to find out how much hdd space has to be bought to accomodate future requirements.
The Table definition and index definitions are already present.
how do i calculate space. i do not want an average but to get the max size based on the data types in bytes
This script is my personal estimate sizing script - it won't give you an answer but will hopefully help you to arrive at your own answer. I use it to
a: Estimate eventual table sizes
b: Decide tablespace sizes, initial extents etc
You will probably have to run it repeatedly with different initial extent/extent sizes to arrive at a suitable sizing scenario. Also, it's updated and messed around with as and when, so it's worth looking through to see it works for you.