ORA-01031 with Create Index for a Function Based Index 
Author Message
 ORA-01031 with Create Index for a Function Based Index

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?

  Thanks
  Rishi

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 ORA-01031 with Create Index for a Function Based Index


(if that email address didn't require changing)

Quote:

>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

Quote:
>  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


Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Oracle user defined Function based index and Ora-4020

2. ORA-01031 creating the database;newbie

3. Create Database, ORA-01031 Insufficient Privileges

4. ORA-01031: Create User in Procedure

5. ORA-01031 : Insufficient Privileges error message (on trying to create an OLAP cube in 9i)

6. Function based indexes and index fast full scan

7. ORA-12224 and ORA-01031

8. How I can create a function-based index ?

9. can't create function-based index

10. Creating Function-Based Indexes

11. Error while Creating function based index in Oracle 8

12. ORA-901 Invalid create command when creating BITMAP INDEX


 
Powered by phpBB® Forum Software