When LiveReorg job is running, it encounters the error: "ORA-02294 cannot enable (Primary Key name) - constraint changed during validation". The job is then aborted, and cannot proceed.
From the reorg log file:
[258] 02/21 10:37:57 line=77 sql=Whenever Error Continue;
[258] 02/21 10:37:57 line=78 sql=ALTER TABLE DB.EMPLOYEE Enable Validate PRIMARY KEY
[258] 02/21 11:05:36 ORA-02294: cannot enable (DB..EMPLOYEE_PK) - constraint changed during validation
[258] 02/21 11:05:36 line=79 sql=Whenever Error Stop;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center