Kbase P130864: Oracle Error 00439 when Support of Funtion-based Index in Oracle Is Not Enabled
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/24/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Oracle DataServer
Oracle 8.x
SYMPTOM(s):
Error during ProToOra
Error creating Oracle index during ProToOra
Ora-00439: feature not enabled: Function-based indexes
SEND-SQL FAILED SENDING: CREATE INDEX myindex on my table (upper(fld_name),progress_recid)
Using Oracle 8i
V$options view shows function based index is false
CAUSE:
In OE release, oracle data server no longer generate shadow columns to support case insensitivity. instead, it uses upper function to support this feature. In this specific customer environment, the support for function based index (FBI) is not enabled
FIX:
Enable FBI according to Oracle instructions.