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;
While LiveReorg job was attempting a DDL statement to enable this constraint, another DDL had already changed this same constraint.
Restart the Reorg Job from Script Monitor. Ensure that no other DDL statements are executed against the objects during a LiveReorg Job.
Space Manager is not responsible to ensure exclusive control over the reorganized objects.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center