I want to create a table with 50 million records, i would like to know what are the values i should give for storage structures.
for example - initial extent =?
and so on. Please also tell me, is there any calculation behind this. here my database is going to be 10 gb and the db_block_size =4k .
Note: if somebody knows any good books on this topic , pl suggest me.
Thanks and Regards,
Space calculation for tables/indexes available in Oracle Database administration Manual.
Based on the avg.row size you can approx.estimate how many rows fit into one Block and then you can calculate the total size approx.
Local managed tablespace
You can find the following information very helpful.
Another option is to use LOCAL MANAGED TABLESPACE so that the extent allocation is done by the RDBMS.
Thanks a lot.
I suggest you serioursly look into the LOCAL MANAGED TABLESPACE option.
Click Here to Expand Forum to Full Width