Oracle EE Stage - Regular Indexes and Partition Indexes

[vyyuri]

Hello All ,

I am loading my Oracle table which has Indexes and also Partition Indexes. I can not use Rebuild method, since it has Partition Indexes and even I can not use Maintenance mode since it has regular indexes. Can any body suggest me some approach for this to handle it through DS?

For now I am disabling all the indexes manually, then loading the table and then enabling them again .But this is a manual process, of course still I can call this script from CLOSE command. But is there any way without calling script I can handle it through Datastage?

Regards
Srini