Oracle finds tablename with index name

Question

I have an index name that exists in some table in some column in db (oracle 11g). Knowing the name of the index, how can I find which table it belongs to?

Answer 1

SELECT table_name
FROM all_indexes
WHERE index_name = 'YOUR_INDEX'