How to list contents of index

How do I view the index or tables which I request?

This is what I am doing:

select index_name from dba_indexes where table_name='XYZ';

And the results are coming back empty.

Could someone please give me a hint?

Thank you :)

Quote:

---

Originally Posted by Metablade

Could someone please give me a hint?

---

You either have no indexes on that table or that table doesn't exist.

Yes, that would appear to be the case, however, Query on * was empty.

Would this not show the "entirety" of my tables?
:confused:

what query was empty?

Quote:

---

Originally Posted by Metablade

How do I view the index or tables which I request?

This is what I am doing:

select index_name from dba_indexes where table_name='XYZ';

And the results are coming back empty.

Could someone please give me a hint?

Thank you :)

---

are you logged on as dba or joe user, perhaps select from user/all indexes