开发者

How to Recompile Invalid Java Class Objects in SYS user in an Oracle 10g DB?

I need to upgrade an ORACLE 10g db to 11g, but have tons invalid JAVA CLASS object type objects in an user schema, and 30 invalid JAVA CLASS object type objects in SYS schema, and I read some doc, you should not have any invalid objects in SYS schema prior to the upgrade, but I ran the recompile all objects script utlrp.sql already, those invalid objects (object type is JAVA CLASS)开发者_如何学C are persistent in both the user and SYS schema. So can I go ahead to upgrade the db? Or how can I get rid of those invalid JAVA CLASS object type objects?


Do you have access to My Oracle Support?

Looks like MOS Doc ID 464568.1 may have some good information for you.

Hope that helps.


Try :

alter java class "*Your Class Name Goes Here*" resolve;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜