-
invalid objects after migration 8i to 10g
Hi beloved Friends,
I am now migrating my 8.1.7(aix 4.3.3) database to
10g(10.1.0.3) AIX 5L.
One thing good about OEM 10g is that it warns me that I still have
invalid objects in my database,(even after running the pupbld.sql as
what the patch installer advised) in the monitor screen it says I have
6 objects are invalid in the PUBLIC schema and 14 objects are invalid
in the SYS schema. But when I select count(*) from dba_objects where
status='INVALID' i got a total of 61 objects. Why is this so?
I tried recompiling the object for PUBLIC and SYS:
SQL> alter SYNONYM PUBLIC.ALL_REPGROUPED_COLUMN compile;
alter SYNONYM PUBLIC.ALL_REPGROUPED_COLUMN compile
*
ERROR at line 1:
ORA-00995: missing or invalid synonym identifier
=============================================================
How do I compile a public object?
=============================================================
SQL> alter VIEW SYS._ALL_REPGROUPED_COLUMN compile;
alter VIEW SYS._ALL_REPGROUPED_COLUMN compile
*
ERROR at line 1:
ORA-00911: invalid character
=============================================================
How do I compile an object with a leading "_" name?
=============================================================
SQL> alter PACKAGE BODY SYS.DBMS_SQLTUNE compile;
alter PACKAGE BODY SYS.DBMS_SQLTUNE compile
*
ERROR at line 1:
ORA-00922: missing or invalid option
=============================================================
How do I compile a package body?
=============================================================
Thanks a lot in avance
Ms Congeniality III
-
alter package body OWNER.object_name compile body;
synonyms doesn't have to be compile, check with its
previous existense.
But when I select count(*) from dba_objects where status='INVALID' i got a total of 61 objects. Why is this so?
'cause dba_objects includes all schemas.
-
yes dear, all i have selectd are from PUBLIC and SYS only ...well i just got 1 from my user schema.
I keep on recompiling the SYS objects and it did successfully. but when i check it theres another gets invalid like domino effect.
Thanks a lot
Ms Congeniality III
-
public isnt a user, it doesnt own any objects so nothing to compile.
Run @?/rdbms/admin/utlrp to do the invalid objects
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|