Re: Function based indexes

Niall,

Quite right, and my apologies to the OP - I missed the 'Standard' bit in the original post. Ours is of course EE.

Paul

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3c46a650$0$8510$ed9e5944_at_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 - 11:55:39 CST