Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] system.utl_recomp compile error ????
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_at_perceptron.com>
Reply-To: ineyman_at_perceptron.com
To: <mccdba1_at_yahoo.com>, <oracle-l_at_freelists.org>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Monday, March 06, 2006 1:37 PM
To: oracle-l_at_freelists.org
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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 06 2006 - 16:46:07 CST
![]() |
![]() |