cancel
Showing results for 
Search instead for 
Did you mean: 

object dba_registry does not exist

Former Member
0 Kudos

Hi,

We are performing Preparation Phase for Oracle 9i upgrade.

In check for invalid database objects section, when I ran

SQL> select comp_id, version, status from dba_registry;

got message "object dba_registry does not exist"

I am not sure this is issue or not. Please explain me and tell me solution.

Also when I execute

SQL> select count(*) from dba_objects where status='INVALID';

10

SQL> select owner, object_name, object_type from dba_objects where

status='INVALID'

Displayed 10 objects with details.

Does above result will make any issue for upgrade? Please explain me.

Regards

Srinivas.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

Are you sure that you are reading the proper upgrade manual?

Dba_registry does not exist in 8i

please display results from your last SQL query

Former Member
0 Kudos

Yes Eric, you are correct dba_registry not in 8i. I could not able to find this in Oracle 9i upgrade document. I found this info in Oracle site.

and my last SQL query output

OWNER:SAP<SID>

OBJECT_NAME:BBPV_CTR_LOCAL

VIEW

All other 9 objects names start with BBPV_*

Regards

Srinivas

Former Member
0 Kudos

Hello,

That is an error on the upgrade guide.

It is documented on the note 540021.

Skip that step. But check the note as it contains other usefull information for the upgrade.

former_member204746
Active Contributor
0 Kudos

try running script utlrp.sql (If this exists in 8i) it will recompile all invalid objects.