Thanks a lot PAVB.

Since it is an initial phase, the data volume is less and I followed the solution you provided. Thanks

Do you think data compression will improve further performance in 10gr2 database with Hash partition? Data will be loaded to these tables by each insert and not through bulk. Since compression option will work for bulk load (with append hint or sqlloader), I believe that even if we enable compression option, it will not give any effect for my requirement.

Please let me know if you have different thoughts.