ORA-14134: indexes cannot use both DESC and REVERSE



ORA-14134: indexes cannot use both DESC and REVERSE..

Answer / guest

Cause: An attempt was made to make a reverse index with some
index columns marked DESC.

Action: Do not use DESC in reverse indexes. The rule-based
optimizer can scan indexes backwards, which allows a normal
reverse index to simulate a reverse index with columns
marked DESC.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string

1 Answers  


ORA-07824: sspain: $SETIMR failure

1 Answers  


ORA-36342: (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]

1 Answers  


ORA-12441: policy string already exists

1 Answers  


ORA-02212: duplicate PCTFREE option specification

1 Answers  






TNS-00224: No more connections available

1 Answers  


SQL*Loader-00700: Out of memory while performing essential allocations [number]

1 Answers  


ORA-07820: sspscn: SYS$CRELNM failure

1 Answers  


ORA-07410: slpdtb: number too large for supplied buffer.

1 Answers  


PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

1 Answers  


DRG-10750: unknown parameter string

1 Answers  


DRG-11838: Proxy Reauthentication Required

1 Answers  


Categories