Does any one has table sizing script. I have table with data. Now I need to find that, what should be the intial size, so that I can prepare a script for initial and next ext etc for the table creation script to go for production.
Initiallly the script was prepared with initial and next by guessing some thing.
I also need the same for index.
Populate the table with some sample data, analyze it and check AVG_ROW_LEN. Multiply this by estimated no. of rows.
Its not necessary to pack everything in one extent. Use uniformly sized extents if possible LMT.
Click Here to Expand Forum to Full Width