How to activate function-based indexes?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to activate function-based indexes?

  1. #1
    Join Date
    Sep 2000
    Posts
    78

    Arrow

    Hi,,

    When I try to create function-based index it says that the option is not supported. I have Oracle 8.1.5 Standard Edition. Is this edition provides function-based indexes or I need the Enterprise edition?

    Thanx!

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Do you have the COMPATIBLE initialisation parameter set?

    If not this should be defaulting to Version 8.0.0.

    To use new features of 8i this parameter must be set to the
    version of oracle that contains the features you wish to use
    ie. If you have no applcation conflicts with any feature in 8.1.5
    i suggest you set the parameter to 8.1.5....

    In the init file for the database insert the line (If not already there)

    COMPATIBLE=8.1.5

    This will require the database to the shutdown and restarted.

    Hope this helps....
    Let me know if it solves the problem

    Rgds

    Moff

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width