Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-01632 Error on Index
During a period of large inserts, updates, and deletes to a single table, we received an ORA-01632 error for the single index that exists on this table. The documentation for this error states the cause as: The maximum amount of space allowed for saving undo entries has been reached for the named index. I don't understand how this could happen if we are issuing a COMMIT after each insert, update, or delete. Also, the tablespace that holds this index is sized well above the space needed to hold this index. Where are the index undo entries stored? Isn't all undo information stored in the Rollback Segment? Our Rollback
Segment appears to be sized correctly. Has anyone seen this error or do
you have any information to add?
Thanks in advance. Received on Thu Mar 23 2000 - 10:13:32 CST