Oracle Database Discussions

Hello All,

I have a question on indexes during bulk loads.

I have a partitioned table by range and sub partitioned by a hash value. Each day we expect data around 300MB to fill into the partitioned tables. These tables will be indexed so is there anything special i should be taking care of during the load. Do i need to drop indexes before the load and then rebuild them after the load or is it possible to keep the index state intact and do a rebuild simultaneously along with the load.

Please provide me with ur inputs.

Thanks.