I am working through the UpgradeManager for a 9.1m060 to 10.0m040 upgrade and the Verify Pre Condition check failed. I am not an Oracle expert and we do not have one at this site.
Can someone help me with the commands I need to look at and correct these errors?
Logged Messages:
1. Primary Key Index PK_AUTHORIZATIONAGREEMENT does not exist.
2. Primary Key Constraint PK_AUTHORIZATIONAGREEMENT does not exist.
3. Primary Key Index PK_NAVFILTERDESIGNATIONLINK does not exist.
4. Primary Key Constraint PK_NAVFILTERDESIGNATIONLINK does not exist.
5. Primary Key Index PK_DESIGNATIONGROUP does not exist.
6. Primary Key Constraint PK_DESIGNATIONGROUP does not exist.
7. Primary Key Index Verification Failed :-
8. For any missing primary key index or primary key constraints, follow the steps below for each table reported in the log:- 1) Examine existing constraints on the table and check if there exists any other constraint on the primary key column for that table. 2) If no constraint exists on the primary key column, create the primary key constraint. See example shown below. 3) If a constraint exists on the primary key column, drop the existing constraint and recreate it with the correct name as reported in the log message. For example, If a primary key constraint, PK_WTDocument, is missing on WTDocument, following statement could be used to create it:- ALTER TABLE WTDocument ADD CONSTRAINT PK_WTDocument PRIMARY KEY (idA2A2) USING INDEX; If Primary key constraint exists but Primary key index is missing, create the index as below:- CREATE UNIQUE INDEX PK_WTDocument ON WTDocument(idA2A2); To see the existing constraints on a table, run the following query:- SELECT CONSTRAINT_NAME, INDEX_NAME from USER_CONSTRAINTS where TABLE_NAME='WTDOCUMENT';
