I have a table which is partitioned by month. We keep last few months of records and delete others (drop partition...)

We are using sqlldr to load the data into table.

Intially this table had global index due to the perf. problem we changed it to local index.

Now during the load I want to disable or drop the local index for one of the partition which is going to use during the load so it can improve the perf during the load.

Any suggestion?

Thanks