Kbase P111686: Errro 1437 on protoora due to UPPER() function in CREATE INDEX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/07/2009 |
|
Status: Verified
SYMPTOM(s):
Migration from Progress to Oracle fails with error 1437
Insufficient privilege on operation. (1437)
Statement fails within SQL*Plus with ORA-01031: insufficient privileges
ORA-01031: insufficient privileges
Statement causing problem is: CREATE INDEX ( ... UPPER(...) ...)
FACT(s) (Environment):
No problem to CREATE INDEX ( ... ) without UPPER function
OpenEdge 10.x
Oracle DataServer
CAUSE:
Not enough Oracle privileges
FIX:
Oracle user must be granted CREATE INDEX and QUERY REWRITE, or alternatively be granted CREATE ANY INDEX and GLOBAL QUERY REWRITE permissions.