Here is the script you requested.
Rem
Rem $Header: utlrp.sql 15-nov-2001.10:56:31 rburns Exp $
Rem
Rem utlrp.sql
Rem
Rem Copyright (c) 1998, 2001, Oracle Corporation. All rights reserved.
Rem
Rem NAME
Rem utlrp.sql - UTiLity script Recompile invalid Pl/sql modules
Rem
Rem DESCRIPTION
Rem This is a fairly general script that can be used at any time to
Rem recompile all existing invalid PL/SQL modules in a database.
Rem
Rem If run as one of the last steps during migration/upgrade/
downgrade
Rem (see the README notes for your current release and the Oracle
Rem Migration book), this script will validate all PL/SQL modules
Rem (procedures, functions, packages, triggers, types, views,
libraries)
Rem during the migration step itself.
Rem
Rem Although invalid PL/SQL modules get automatically recompiled on
use,
Rem it is useful to run this script ahead of time (e.g. as one of
the last
Rem steps in your migration), since this will either eliminate or
Rem minimize subsequent latencies caused due to on-demand automatic
Rem recompilation at runtime.
Rem
Rem Oracle highly recommends running this script towards the end of
Rem of any migration/upgrade/downgrade.
Rem
Rem NOTES
Rem * This script must be run using SQL*PLUS.
Rem * You must be connected AS SYSDBA to run this script.
Rem * This script expects the following packages to have been
created with
Rem VALID status:
Rem STANDARD (standard.sql)
Rem DBMS_STANDARD (dbmsstdx.sql)
Rem * There should be no other DDL on the database while running
the
Rem script. Not following this recommendation may lead to
deadlocks.
Rem
Rem MODIFIED (MM/DD/YY)
Rem gviswana 11/12/01 - Use utl_recomp.recomp_serial
Rem rdecker 11/09/01 - ADD ALTER library support FOR bug 1952368
Rem rburns 11/12/01 - validate all components after compiles
Rem rburns 11/06/01 - fix invalid CATPROC call
Rem rburns 09/29/01 - use 9.2.0
Rem rburns 09/20/01 - add check for CATPROC valid
Rem rburns 07/06/01 - get version from instance view
Rem rburns 05/09/01 - fix for use with 8.1.x
Rem arithikr 04/17/01 - 1703753: recompile object type# 29,32,33
Rem skabraha 09/25/00 - validate is now a keyword
Rem kosinski 06/14/00 - Persistent parameters
Rem skabraha 06/05/00 - validate tables also
Rem jdavison 04/11/00 - Modify usage notes for 8.2 changes.
Rem rshaikh 09/22/99 - quote name for recompile
Rem ncramesh 08/04/98 - change for sqlplus
Rem usundara 06/03/98 - merge from 8.0.5
Rem usundara 04/29/98 - creation (split from utlirp.sql).
Rem Mark Ramacher (mramache) was the original
Rem author of this script.
Rem
Rem
Rem BEGIN utlrp.sql
Rem
--
--
--
*********************************************************************
-- NOTE: Package STANDARD and DBMS_STANDARD must be valid before
running
-- this part. If these are not valid, run standard.sql and
-- dbms_standard.sql to recreate and validate STANDARD and
DBMS_STANDARD;
-- then run this portion.
--
*********************************************************************
@@utlrcmp.sql
execute utl_recomp.recomp_serial();
Rem
=====================================================================
Rem Run component validation procedure
Rem
=====================================================================
EXECUTE dbms_registry.validate_components;
Rem
===========================================================================
Rem END utlrp.sql
Rem
===========================================================================
On 10/21/2003 12:59:25 PM, Seema Singh wrote:
> Hi,
> Can someone send all object compilation script?
> Thx
> -Seema
>
> _________________________________________________________________
> Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up
> Internet Service. Try it FREE for one month!
> http://join.msn.com/?page=dept/dialup
>
>--
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
> Author: Seema Singh
> INET: oracledbam_at_hotmail.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).
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mladen_at_wangtrading.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 Tue Oct 21 2003 - 13:09:25 CDT
