sqloracle-databaseoracle11g

Oracle find tablename given an index name

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

Solution 
  • SELECT table_name
FROM all_indexes
WHERE index_name = 'YOUR_INDEX'