Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] system.utl_recomp compile error ????

RE: [Q] system.utl_recomp compile error ????

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 06 Mar 2006 17:46:07 -0500
Message-ID: <BAY102-F2535308DC2E9CDCBA2A889A1E90@phx.gbl>


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.



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 06 2006 - 16:46:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US