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: Replication : ORA-04068: existing state of packages has been

Re: Replication : ORA-04068: existing state of packages has been

From: Jared Still <jkstill_at_cybcon.com>
Date: Sat, 25 Oct 2003 15:49:24 -0800
Message-ID: <F001.005D45BC.20031025154924@fatcity.com>


Thanks Pete, that was the one.

Jared

On Sat, 2003-10-25 at 15:09, Pete Finnigan wrote:
> >
> >There's another script for this as well, but I can't recall
> >it at the moment. The above script is generally used as
> >a final step in an upgrade.
> >
> >Jared
>
> Hi Jared,
>
> Did you mean:
>
> utlirp.sql - UTiLity script to Invalidate & Recompile Pl/sql modules
>
> Which does the extra invalidate first that utlrp.sql doesn't do.
> utlirp.sql uses utlip.sql first to invalidate all PL/SQL and then uses
> utlrp.sql to recompile all the invalid packages.
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:pete_at_petefinnigan.com
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pete Finnigan
> INET: oracle_list_at_peterfinnigan.demon.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sat Oct 25 2003 - 18:49:24 CDT

Original text of this message

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