Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Version 4.0.0.12 (EA) - functional indexes of a table are listed twice

MPf_dbadataGmbHJul 31 2013 — edited Jul 31 2013

Hello,

it seems that functional indexes are listed twice if there are two functions within the index columns.....

Example (Content from the indexes tab of the table view):

owner    ....._PK    UNIQUE    VALID    NORMAL    N    NO NO    ....._UUID 

owner    ....._UI1    UNIQUE    VALID    FUNCTION-BASED NORMAL    N    NO    ENABLED    NO    SYS_NC00016$, SYS_NC00017$, ....._ID, ....._PLAN_ID    SYS_EXTRACT_UTC("....._START")

owner    ....._UI1    UNIQUE    VALID    FUNCTION-BASED NORMAL    N    NO    ENABLED    NO    SYS_NC00016$, SYS_NC00017$, ....._ID, ....._PLAN_ID    SYS_EXTRACT_UTC("....._END")


Both functions are in the same index "....._UI1".

The detail panel shows the same details.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2013
Added on Jul 31 2013
2 comments
494 views