Re: declare SYS.DBMS_PIPE???

Greg G wrote:

>
>
> Daniel Morgan wrote:
>
>> You can run export, look up the syntax, to verify logical integrity.
>> No need to export data to do this.
>
>
> Got it. Already posted those results.
>
>> If this is a production box someone had better take this a bit more
>> seriously than "we have a hands
>> off policy until it crashes into the ground and burns. Which is where
>> it may well be headed. You have
>> more than a serious problem if trying to grant a privilege hangs
>> indefinitely: Treat it as such.
>
>
> Yep. I'm aware of that, and I'm trying to impress that on the
> management here.
>
> -Greg G
>

Based on your post it appears there may well be one or more logical errors.

Try this:

SELECT object_name, object_type
FROM dba_objects
WHERE status = 'INVALID';

just to see if there are other things to think about.

At this point I would open an iTAR and while waiting I'd look into trying to identify all
nested tables and find the DDL for rebuilding them. That isn't going to solve the GRANT
issue but sure seems like a sensible approach.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)