lookupIndexColumnns

I have an index on a table with a name IDX_UNIQUE_T1 and column name is SYS_NC00072$

I am trying to figure out the columns for this inde from user_ind_columns but can't tell what it is.

any ideas how>
sam15Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johanntagleCommented:
Should be simple.  What does the ff query give you:

select column_name from user_ind_columns where index_name='IDX_UNIQUE_T1'
0
devindCommented:
Try following to get DDL for Index

select  DBMS_METADATA.GET_DDL('INDEX','PERSON_IDX') from DUAL;

for more examples refer to http://blogs.sun.com/mandalika/entry/oracle_extracing_the_table_index
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sam15Author Commented:
the first statement gives me the same column name "SYS_NC00072$" for column name.

the second SQL did not work. I think 9202 has issues or a bug with this the DBMS_METADATA or it is not supported.

I found the DDL using TOAD and the index is function based index.

CASE WHEN BKNO > 20000 THEN MEDIUM||','||TO_CHAR(BKNO) ELSE NULL END

not sure why the FBI does not show a valid column name. I think thsi index is enforcing a uniqe values on the combination of the two columns for numbers larger than 20000.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.