Return
-
Title
Reorg failed after an index in the target table was renamed -
Description
Reorg failed after an index in the target table was renamed. How to resolve the situation?
-
Cause
The index was was renamed during script generation. The Reorg script failed renaming the missing index.
-
Resolution
RESOLUTION 1
1. Clean up the aborted script
2. Create a new scriptRESOLUTION 2
1. Rename index back to original name in Oracle
2. Manually run the Live Reorg script from the section after the error occurred.