Hi,
when I use Oracle Stage with option LOAD/APPEND to load 2 lac records in a table its indexes become in unusable state.
Moreover I made oracle stage "Sequential".
Also, I tried with option "Index Rebuild" in Oracle Stage. But it also didn't help.
One solution whcih i see is just drop the indexes & recreate them after data being loaded. But this solution doesn't seem feasible to me as I have to load no. of tables & those tables have so many indexes.
Is there any other solution? can something be done in Job itself so this problem doesn't come.
Thanks in advance!!
Regards,
Vinod
Index in Unusable state
Moderators: chulett, rschirm, roy
Index in Unusable state
Thanks & Regards,
Vinod
Vinod