Oracle database error code ORA-14134 – indexes cannot use both DESC and REVERSE

Oracle Database Error Code ORA-14134 Description :
indexes cannot use both DESC and REVERSE
Error Cause:
An attempt was made to make a reverse index with some index columns marked DESC.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»