RE: idl_ub2$ and utlip.sql
- From: "Hallas, John (EXP N-ARM)" <john.hallas@xxxxxxxx>
- To: ujang.jaenudin@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Jul 2007 10:06:36 +0100
DESCRIPTION
Rem This script can be used to invalidate all existing PL/SQL
modules
Rem (procedures, functions, packages, types, triggers, views) in a
Rem database so that they will be forced to be recompiled later on
Rem either automatically or deliberately.
Rem
Rem This script must be run when it is necessary to regenerate the
Rem compiled code because an action was taken that caused the old
code's
Rem format to be inconsistent with what it's supposed to be, e.g.,
when
Rem migrating a 32 bit database to a 64 bit database or vice-versa.
Rem
Rem STEPS:
Rem
Rem (I) Invalidate all stored PL/SQL units (procedures, functions,
Rem packages, types, triggers).
Rem
Rem (II) Reload PL/SQL package STANDARD and package DBMS_STANDARD.
Rem
Rem (III) Selectively invalidate views and synonyms
Rem
Doesn't seem high risk as long as you recompile everything afterwards.
Use utlrp for that
Why not log a SR
You could try and fix the corrupt blocks with dbms_repair.check_object
procedure and dbms_repair.fix_corrupt_blocks
More importantly, how has the corruption occurred
John
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ujang Jaenudin
Sent: 25 July 2007 04:15
To: oracle-l@xxxxxxxxxxxxx
Subject: idl_ub2$ and utlip.sql
folks,
I have problem on system tablespace, corruption on object idl_ub2$,
searching google that idl_ub2$ can rebuild by utlip.sql, is it true?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
