It is duplicate now. One owned by SYS and one owned by SYSTEM. You may drop
it safely owned by SYSTEM. Just make sure that SYS also has this object
before dropping it.
Regards Rafiq
From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx> Reply-To: ineyman@xxxxxxxxxxxxxx To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx> Subject: RE: [Q] system.utl_recomp compile error ???? Date: Mon, 6 Mar 2006 13:47:31 -0500
Start with:
Show errors package body utl_recomp;
to find, what are the specific errors.
Btw., did you try to recompile it when connected as system (or under some other account)?
Igor
-----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Monday, March 06, 2006 1:37 PM To: oracle-l@xxxxxxxxxxxxx Subject: [Q] system.utl_recomp compile error ????
I by accident run "@?/rdbms/admin/utlrp" use "system" account. I have error come out:
SQL> alter package system.utl_recomp compile body;
Warning: Package Body altered with compilation errors.
Anyone know how to get ride of this problem?
Thanks.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l