Index Rebuilding on Huge Tables
Dear All,
1. we are in process of rebuilding an index on table A
2. Insert operation on this table A is huge. 24*7 insertion is going on.
3. During the rebuild process the insertion process in very slow and gives some ORA-7445 Error. So right now we are doing the index rebuild by stopping the insert operation.
4. We want to perform the index rebuild process with out stopping the batch jobs.
if anywork around is available,kindly share.
Thanks in Advance