RE: Two (probably simple) questions, function based index and table p

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Fri, 17 Aug 2001 03:00:30 -0700
Message-ID: <F001.0036E848.20010817030025@fatcity.com>

What version of Oracle are you using?
Function based indexes only work in EE.

Rick

-----Original Message-----
Sent: Friday, August 17, 2001 6:46 AM
To: Multiple recipients of list ORACLE-L p

Hello folks!

I need to create a function based index, but when I do this, Oracle gives me the message ORA-00439, function not installed, so I have tried and tried to figure out how to install this function, but I have failed, therefore this e-mail. I have looked in ORACLE_HOME/rdbms/admin and read the manual but without sucess.

I have the same problem with table partitioning, where I have not figured out how to install that option either.

Thanks

/Jonas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jonas A Wetterberg
INET: jonas.a.wetterberg_at_manpower.se

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: Cale, Rick T (Richard)
INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------