Re: Morgan's Problem D'Jour

Daniel Morgan wrote:

> Brian Peasland wrote:
> 
> If no one has any more ... it is time to open a TAR and let someone
> inside Oracle sweat this one.

Here's the response from Oracle's documentation people. And it indicates the problem is a bit wider than I found. (Names removed to protect the innocent).

> Hi F........ The COMMENT statement got two additions for the
> extensible indexing project of the 9.1 > release: COMMENT ANY
> INDEXTYPE and COMMENT ANY OPERATOR. In theory, two corresponding
> privileges were added as well.
>
> My tests show that the privileges were not added, and I get the same
> result as Dan on the COMMENT ANY OPERATOR statement. I think we have
> some code bugs here, as well as some doc that possibly has to change.
>
> I'll find out who is responsible for the extensible indexing material
> these days and follow up.

So there you have it ... don't try to COMMENT anything other than tables and columns.

At least for now.

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