on 03-01-2007 7:45 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.