Re: ORA-01031 with Create Index for a Function Based Index

A copy of this was sent to rishiv_at_my-deja.com (if that email address didn't require changing) On Sat, 19 Feb 2000 04:08:46 GMT, you wrote:

>Hello all,
> I'm getting ORA-01031: insufficient privileges while trying to
>create a function index.
>
>-- Statements --
> create table date_ind_test
> ( id number not null,
> creation_date date );
>
> create index date_ind on date_ind_test
>(to_char(creation_date,'DHH24'));
>
>-- Error returned --
>create index date_ind on date_ind_test (to_char(creation_date,'DHH24'))
> *
>ERROR at line 1:
>ORA-01031: insufficient privileges
>-- End Error
>
> Any ideas on privileges to be set up to use function indexes?
>

see
http://osi.oracle.com/~tkyte/article1/index.html#how

> Thanks
> Rishi
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Feb 19 2000 - 07:51:27 CST