Re: catalog/catproc as system

From: Dave <x_at_x.com>
Date: Tue, 16 Aug 2005 19:38:29 GMT
Message-ID: <VgrMe.90180$G8.3175@text.news.blueyonder.co.uk>

"Vince Bono" <vjb_at_netlabs.net> wrote in message news:QICdnX638ajCmZ_eRVn-gg_at_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
>

yes, ou drop object which should be owned by system which are invalid Received on Tue Aug 16 2005 - 14:38:29 CDT