Re: declare SYS.DBMS_PIPE???

Greg G wrote:

>
>
> Daniel Morgan wrote:
>
>> Whoever is managing this little shop of horrors should go back to
>> basics. Bounce the
>> server. Does the GRANT still hang? If so I'd be running export to
>> verify logical integrity,
>> catalog.sql, catproc.sql, etc. Bounce the sever again. Does the GRANT
>> still hang? If so
>> I'd be opening an iTAR.
>
>
> In fact, the server was bounced about a week ago. Unfortunately, I
> can't do that whenever I want, as it's a production box and there's a
> boojum-load of processes that connect to the thing.
> Forgive my ignorance, but how will running export verify logical
> integrity? Or do you mean for me to export and then re-import
> everything. That's not really feasable as this database is gimungous.
>
> -Greg G
>

You can run export, look up the syntax, to verify logical integrity. No need to export data to do this.

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.

-- 
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)