Correcting problems found by the SQL Object Consistency Analyzer involves deleting the invalid data and restoring the constraint, plan, or view to its original condition.
Important! First make backups of the following areas:
If you no longer need the constraint, plan, or view in question, you can skip the steps that involve saving the source and re-creating the constraint, plan, or view. All reports and documentation produced should be saved until successful re-creation or deletion of the constraint, view, or plan has been achieved. If you call CA Support during this process, have the necessary documentation ready for their use.
The remainder of this section is divided into three areas:
|
Copyright © 2014 CA.
All rights reserved.
|
|