Skip to Main Content

Oracle Database Discussions

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!

Unique Index and "SYS_NC00012$"

user511621Mar 9 2011 — edited Mar 9 2011
hi bolow is the index creation scritpt i have created it in on of the table
CREATE UNIQUE INDEX TESTUK_05
ON TEST (COL1_NO,
             COL2_NO,
             COL3_DATE,
             COL4_NO DESC)
PCTFREE 002
INITRANS 5
STORAGE (
          INITIAL 200M
          PCTINCREASE 0
        )
TABLESPACE USERS;
but when i m quering table user_ind_columns it is showing me some different column name in place of last column which is "col4_no"
select TABLE_NAME,INDEX_NAME,COLUMN_NAME from user_ind_columns where table_name='TEST' order by INDEX_NAME;

TEST      TESTUK_05            COL3_DATE
TEST      TESTUK_05            COL2_NO
TEST      TESTUK_05            COL1_NO
TEST      TESTUK_05            SYS_NC00012$
PLEASE TEL ME WHY IT IS GIVING COLUMN NAME AS "SYS_NC00012$" INSTEAD OF COL4_NO
This post has been answered by Hemant K Chitale on Mar 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2011
Added on Mar 9 2011
4 comments
2,060 views