반품
-
제목
Error: "ORA-02294 Error while attempt to enable index constraint" -
설명
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;