Re: catalog/catproc as system

From: Vince Bono <vjb_at_netlabs.net>
Date: Tue, 16 Aug 2005 11:22:05 -0400
Message-ID: <QICdnX638ajCmZ_eRVn-gg@netlabs.net>

I found a script that will generate sql to remove all 'INVALID' objects.

select 'drop '||object_type||' ' ||owner||'.'|| chr(34) ||object_name || chr(34)||';' from dba_objects where status = 'INVALID' and owner='SYSTEM';

 I added owner = SYSTEM to the end. And then plan to run

@catalog
@catproc
@catexp

afterwards...
Is there any known pitfall to this approach ?

-Vince

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1124139202.243614.78020_at_z14g2000cwz.googlegroups.com...
> Look at dba_objects for objects that exist both under user SYS and user
> SYSTEM. Drop the SYSTEM owned version.
>
> Check that the public synonyms for the dictionary objects all point to
> the SYS owned version and not to a SYSTEM owned version.
>
> Rerun catexp as user SYS.
>
> HTH -- Mark D Powell --
>
Received on Tue Aug 16 2005 - 10:22:05 CDT