How to find out the size of the datafile for a database consist of three tables with following specs:
1 year growth 5 Year growth
Table 1 400,000 record/year, 1 million record/5 year
Table 2 100, 000 record/year, 250, 000 records/5 year
Table 3 45/year, 60/5 year
Table1: Average Record length: 80
Table 2: Average Record length 100
Table3: Average Record length 35
I really need to understand this concept. Also I would like to understand the magic about min. extent, maxextents....
in short storage clause for the tables.
I really need help.
Click Here to Expand Forum to Full Width