Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index Rebuilding on Huge Tables

user585870Apr 13 2010 — edited Apr 13 2010
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

Comments

1. Use code tags when you post code.
2. Post the entire method.
EJP
C++ has much stricter type-checking than C.

This is not a JNI question. Try a C+ forum.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2010
Added on Apr 13 2010
#general-database-discussions, #index
8 comments
5,924 views