Oracle error ORA-1502 during index rebuild

출처:  https://metalink.oracle.com/



Title
=====
Oracle error ORA-1502 during index rebuild.


Problem
=======
When you attempt to rebuild indexes on a table which is frequently being written to by other processes, the index rebuild may fail.


Explanation
===========
While index rebuilding is intended to allow write access to the table while the index is being built, there is a brief period of time during which the table must be locked in order to complete the index rebuild process.

If the index rebuild is unable to lock the table, then eventually the index rebuild will fail with an ORA-1502 error. At this point the index will be left in an unusable state. This will require the index to be recreated.


Solution
========
When rebuilding an index, you must make sure that the write activity on the table affected is minimal, or perform an online index rebuild.


Keywords
========
Index rebuild; ORA-1052