#96 Does not find Oracle Descending Indexes

[KentG]

I have a table with descending indexes. They are not found by SchemaSpy. I assume that is because Oracle stores descending indexes like they are a state secret.

Oracle's Descending indexes are a pain... The name of the descending column is not reported in catalogue views. Instead the column name is replaced with a system generated column name. Therefore, for descending indexes the table and column names need to be cross referenced against one of the following ...
1. “sys.dba_ind_expressions” table ( column name: “COLUMN_EXPRESSION” ).
2. “sys.all_ind_expressions” table ( column name: “COLUMN_EXPRESSION” ).
3. “sys.col$” table ( column name: “DEFAULT$” ).

I am not an expert - Maybe you have a better solution - or maybe I am wrong about the cause.

[John Currier]

selectIndexesSql in ora.properties can be customized to do this type of thing. The current SQL returns a null for asc_or_desc. That is, it doesn't attempt to figure it out. Someone with significantly more Oracle experience than I have will need to provide a solution.

If asc/desc is of value to you then please modify the SQL and post the results here.

John

[John Currier]

Evidently nobody has the appropriate SQL, so I'm marking the bug 'pending'.

[SourceForge Robot]

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).