I can only access my working environment only using a unix prompt. I log in with sqlplus and did a query to see what indexes my table X has. I got X_PK and X_1IX as a result.
I then proceed to Query to see what column names those are based on, my PK returns a serial number as expected but when i tried X_1IX i get SYS_NC00022$ which doesn't show with the describe command on that table. I know some basics of function based indexes.
I need to find out how and on what columns it was created so i can reproduce it. How can i find these things out?
Are there any tables i can query?