A reorg job terminates with the error;
ORA-01452 cannot CREATE UNIQUE INDEX; duplicate keys found
This has been seen when there was corruption in the table/index.
Execute the command;
SQL>analyze table <table_name> validate structure cascade;
Any errors returned bt the analyze should be reported to Oracle for resolution.
If the analyze completes without error, please create a case with Quest Support.
The reorg job will need to be cleaned up if it cannot be restarted. Details of this operation can be found in SOL28061.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center