Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based index on Standard Edition

Re: Function based index on Standard Edition

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 26 Jun 2002 19:36:40 +0200
Message-ID: <uhjv485s9k238b@corp.supernews.com>

"Stephen B" <stephen.bell_at_cgi.ca> wrote in message news:m%kS8.7650$z_5.748858_at_news20.bellglobal.com...
> Hi all,
>
> I've started searching the archives on this but there are many postings on
> function based indexes and all (so far) are
> more detailed than I need..
>
> My question is simply
>
> "Does the Standard Edition of 8.1.7 support function based indexes?"
>
> or do I need the Enterprise Edition...
>
> Any thoughts appreciated!
>
> Steve
>
>

The Standard Edition doesn't support Function Based Indexes. Please verify by select * from v$option.

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address


Regards
Received on Wed Jun 26 2002 - 12:36:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US