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 -> function based indexes

function based indexes

From: Kumar <kumar_kmk_at_hotmail.com>
Date: 14 Nov 2002 18:02:53 -0800
Message-ID: <bce41b15.0211141802.7872a762@posting.google.com> 





Hi


I am trying to create a function based index and getting 
ORA-00439 : feature not enabled function based indexes.



I looked in v$option table and i find the parameter "function based
indexes" with value false.



Question: how do i make it true (to enable fn based index)



I tried like this:


" update v$option set value ='true' where parameter like
'Function-based indexes'


I got an error saying can only select from fixed tables/views



Thanks for any responses



kumar
Received on Thu Nov 14 2002 - 20:02:53 CST












Original text of this message













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