RE: Number / 0 (solve)

From: Sinard Xing <sinardyxing_at_bcs-ach.com.sg>
Date: Tue, 05 Mar 2002 01:58:25 -0800
Message-ID: <F001.0041F455.20020305015825@fatcity.com>

Hi,

Connect sys

For the creation of a function-based index in your own schema, you must be granted the CREATE INDEX and QUERY REWRITE system privileges. To create the index in another schema or on another schema's tables, you must have the CREATE ANY INDEX and GLOBAL QUERY REWRITE privileges.

You must have the following initialization parameters defined to create a function-based index:

QUERY_REWRITE_INTEGRITY must be set to TRUSTED

QUERY_REWRITE_ENABLED must be set to TRUE

COMPATIBLE must set to 8.1.0.0.0 or a greater value

The result :

SQL> create index myfindex on emp(income/0); create index myfindex on emp(income/0)

                                   *

ERROR at line 1:
ORA-01476: divisor is equal to zero

Sinardy

-----Original Message-----
Sent: 05 March 2002 16:38
To: Multiple recipients of list ORACLE-L

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
  INET: sinardyxing_at_bcs-ach.com.sg

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinard Xing
  INET: sinardyxing_at_bcs-ach.com.sg

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

Received on Tue Mar 05 2002 - 03:58:25 CST