Hi,

We are planning to use HASH partition for one of the large volume table. (There is no date field and planning to do HASH based on the ID)

The expected inflow for that table is 16000000 records and retention of data is 7 years. So the end of the 7th year the record count would be 112000000.

Questions:
1. Planning to have 256 partitions, but it looks too high as well. Any suggestion?
2. If I make 128 for now and then if I add the partition later, is oracle will distribute the records properly or initial partition will be overloaded?

Thanks in advance for your help