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
Oracle EE Stage - Regular Indexes and Partition Indexes
Moderators: chulett, rschirm, roy