27; ||
> OWNER||'.'||OBJECT_NAME || ' compile;'
> )
> from
> dba_objects a,
> sys.order_object_by_dependency b
> where
> A.OBJECT_ID = B.OBJECT_ID(+) and
> STATUS = 'INVALID' and
> OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAG
'VIEW' )
> order by
> DLEVEL DESC,
> OBJECT_TYPE,
> OBJECT_NAME;
>
> spool off
>
> @comp_all.tmp
>
>
>
> > -Original Message-
> > From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 17, 2001 2:25
:
root@fatcity.Subject: Re: RECOMPILE INVALID OBJECTS
com
Can't look at the moment, but doesn't "?/rdbms/admin/utlrp.sql" do this for
you?
--Scott
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 17, 2001 12:20 PM
> Group,
> Does anyone have some SQL handy that will re-compile INVALID
Sent by: Subject: RE: RECOMPILE INVALID
OBJECTS
[EMAIL PROTECTED]
om
12/17/01 11:25
AM
Please respond
to O
ies. I've had to run it multiple times
in order to recompile all objects.
Jared
"Mohan, Ross"
SMI.com> cc:
Sent by: Subject: R
Subject: RE: RECOMPILE INVALID OBJECTS
[EMAIL PROTECTED]
thanks...that makes great sense.
-Original Message-
Sent: Monday, December 17, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L
There was a bug related to dbms_utility.compile_schema where order by
dependency was missing. It may have been fixed, but we still stick with our
ho
;, 'PACKAGE', 'FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
order by
DLEVEL DESC,
OBJECT_TYPE,
OBJECT_NAME;
spool off
@comp_all.tmp
> -Original Message-
> From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
&
There was a bug related to dbms_utility.compile_schema where order by
dependency was missing. It may have been fixed, but we still stick with our
homegrown script.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at E
Title: RE: RECOMPILE INVALID OBJECTS
> from dba_objects A, sys.order_object_by_dependency B
Doesn't work under 8.1.6, there is not
such view as 'sys.order_object_by_dependency',
however,
you can replace this with an inline view of
from
dba_objects a,
I use the following and take a look at the script revaldte.sql before
I run it but you can certainly start it from the same SQL script
this is from SQL & PL/SQL Annotated Archives -- Loney and Carmichael
ttitle off
set pagesize 0 feedback off verify off heading off term off echo off
spool reva
just out of curiousity, does this buy one something extra over/above:
execute dbms_utility.compile_schema('');
-Original Message-
Sent: Monday, December 17, 2001 1:58 PM
To: Multiple recipients of list ORACLE-L
start --
set headin
start --
set heading off
set pagesize 0
set linesize 79
set verify off
set echo off
spool recomp_all.tmp
select decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE |
Hi
I just created last week.
package:
set pagesize 1000;
set heading off;
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;'
from dba_objects
where status='INVALID'
and object_type <> 'PACKAGE BODY';
package body:
set pagesize 1000;
set heading off;
select 'alter package
Group,
Does anyone have some SQL handy that will re-compile INVALID objects for a
given user, that they would be willing to share??
TIA
Al Rusnak
804-734-8453
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rusnak, George A.
INET: [EMAIL PROTECTE
16 matches
Mail list logo
