Sinardy
You are trying to create a function based index. To do so you need the query rewrite privilege
The index will still fail with a divide by 0 error (don't know why you are dividing by zero)
AS USER
create index wrong_logic on john(income/0) *
ERROR at line 1:
ORA-01031: insufficient privileges
AS SYS
SQL> connect internal
Connected.
SQL> grant query rewrite to user;
AS USER
SQL> create index wrong_logic on john(income/0);
create index wrong_logic on john(income/0)
*
ERROR at line 1:
ORA-01476: divisor is equal to zero
1* create index wrong_logic on john(income/4)
SQL> /
Index created.
HTH
John
-----Original Message-----
From: Sinard Xing [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 08:38
To: Multiple recipients of list ORACLE-L
Subject: Number / 0
Hi guys,
This is my test:
SQL> desc emp
Name Null? Type
----------------------------------------- -------- ------------------------
----
EMPNO NOT NULL CHAR(3)
NAME VARCHAR2(10)
INCOME NUMBER(5)
SQL> create index no_logic on emp(income);
Index created.
SQL> drop index no_logic;
Index dropped.
SQL> create index wrong_logic on emp(income/0);
create index wrong_logic on emp(income/0)
*
ERROR at line 1:
ORA-01031: insufficient privileges
I don't understand why Oracle throw such exception (reply).
Do you have any idea what is Oracle doing when Oracle find out number / 0
Sinardy
=========================================================
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by telephone or email
(to the numbers or address above) immediately.
=========================================================