Invalid Objects After Upgrade From 9.2.0.8 to 10GR2 version (Doc ID 404219.1)

Last updated on SEPTEMBER 13, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 9.2.0.8 - Release: 9.2 to 9.2
Information in this document applies to any platform.
Enterprise editon , Standard Editon, Personal Edition, migration for 9.2.0.8 to 10G (10.1.0.2 - 10.2.0.3)

Symptoms

Invalid objects after migrate one database for 9.2.0.8 to 10.2.0.1.

SYS V_$KQRPD VIEW
SYS V_$KQRSD VIEW
SYS GV_$KQRPD VIEW
SYS GV_$KQRSD VIEW
PUBLIC GV$KQRSD SYNONYM
PUBLIC GV$KQRPD SYNONYM
PUBLIC V$KQRSD SYNONYM
PUBLIC V$KQRPD SYNONYM

-- Steps To Reproduce:
Install the 9.2.0.8 patchset and run the dbua to 10G ( 10.1.0.2 -10.1.0.5,10.2.0.1 -10.2.0.3)

Changes

Upgrade for 9.2.0.8 to 10G

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms