Expected Indexes Not Created When Upgrading From 7.6.2 To 11gR1 Bp1 (Doc ID 1562980.1)

Last updated on MARCH 19, 2019

Applies to:

Symptoms

After upgrading from 7.6.2 to 11gR1, the upgrade utility output shows that the expected indexes were not created for some tables.

Steps taken:

1. Upgrade 7.6.2 environment to 11gR1.
2. Run the upgrade utility to ensure that the expected database schema changes were made.


In the resulting systeminfo.log generated by the upgrade utility, we can see that the expected indexes are not there:

e.g. (PRE-UPGRADE is the current status of the table, POST-UPGRADE is what it should be):

PRE-UPGRADE information for : ADVCOLS_DIM table
Table Name: ADVCOLS_DIM
Number of column :4
ID NUMBER 38 false
CS_OWNERID NUMBER 38 false
CS_DIMENSIONTYPE VARCHAR2 32 false
CS_DIMENSIONID VARCHAR2 32 false

INDEXES
Name: I1369058270419 Columns: CS_OWNERID,CS_DIMENSIONID Type: tableIndexClustered Unique: true
Name: SYS_C00177189 Columns: ID Type: tableIndexClustered Unique: true

POST-UPGRADE information for
Table Name: ADVCOLS_DIM
Number of column :4
ID NUMBER 38 false
CS_OWNERID NUMBER 38 false
CS_DIMENSIONTYPE VARCHAR2 32 false
CS_DIMENSIONID VARCHAR2 32 false

INDEXES
Name: FW_1332072316436 Columns: ID,CS_OWNERID Type: tableIndexClustered Unique: false
Name: FW_1332072316439 Columns: CS_DIMENSIONTYPE,CS_DIMENSIONID Type: tableIndexClustered Unique: false
Name: FW_1332072316437 Columns: CS_OWNERID Type: tableIndexClustered Unique: false
Name: FW_1332072316438 Columns: CS_DIMENSIONID Type: tableIndexClustered Unique: false
Name: SYS_C008310 Columns: ID Type: tableIndexClustered Unique: true
Name: I1332072316435 Columns: CS_OWNERID,CS_DIMENSIONID Type: tableIndexClustered Unique: true
table


Additionally, checking the database manually shows that the expected indexes are not there.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.