Re: Aarrrggghhh!!! Creating an index shouldn't be so hard!

IT WORKED!!!!! [dancing about]

<rant>
I guess it's too much to ask that Oracle could mention this requirement in the section titled "Creating a Function-Based Index", rather than requiring you to linearly read the entire doc set. I suppose that's the difference between "push" docs and "pull" docs.
</rant>

At 04:35 PM 10/4/00 -0800, you wrote:
>
>
>grant query rewrite to sysop;
>
>
>Dennis Taylor wrote:
>>
>> At 02:49 PM 10/4/00 -0700, you wrote:
>> >>>>
>> RE: Aarrrggghhh!!! Creating an index shouldn't be so hard!
>>
>> grant CREATE INDEX to sysop
>>
>> <<<<
>>
>> SQL>
>> SQL> show user
>> USER is "SYS"
>> SQL> grant create index to sysop;
>> grant create index to sysop
>> *
>> ERROR at line 1:
>> ORA-00990: missing or invalid privilege
>>
>> ---
>> Dennis Taylor
>> ---
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Binley Lim
> INET: binley.lim002_at_winz.govt.nz
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>

---
Dennis Taylor
---
Don't worry about people stealing your ideas.  If your ideas
are any good,