Re: invalid field definition error [message #39564] |
Tue, 23 July 2002 13:09 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
The "renaming" of the column is because an index created with ASC or DESC is created as a function-based index, and the DESC in your sample is treated as an expression. In fact, look at dba_ind_expressions to see this translation. From the docs:
Oracle treats descending indexes as if they were function-based indexes. You do not need the QUERY REWRITE or GLOBAL QUERY REWRITE privileges to create them, as you do with other function-based indexes. However, as with other function-based indexes, Oracle does not use descending indexes until you first analyze the index and the table on which the index is defined.
I do not have any information as to why you are receiving the error message.
|
|
|