Re: Function based indexes

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 17 Jan 2002 10:24:15 -0000
Message-ID: <3c46a650$0$8510$ed9e5944@reading.news.pipex.net>

And the documentation is correct

SQL> select * from V$version;

BANNER

---

Oracle8i Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production

SQL> create index i_uname on t(upper(name)); create index i_uname on t(upper(name))
*
ERROR at line 1:
ORA-00439: feature not enabled: Function-based indexes

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message
news:g2p18.31366$Hg7.3187865_at_news11-gui.server.ntli.net...


> The documentation used to say the function based indexes where enterprise

> edition (ie not standard) only.

>

> Paul Brewer <paul_at_paul.brewers.org.uk> wrote in message

> news:3c45e71c$1_2_at_mk-nntp-1.news.uk.worldonline.com...

> > Seems to work OK on 8.1.6 and up... haven't tested it on 8.1.5

Received on Thu Jan 17 2002 - 04:24:15 CST