Is there some way to get a list of all the indexes on a particular table using SQL*Plus?
I created a table
CREATE TABLE temp(
id NUMBER PRIMARY KEY,
name VARCHAR2(20));
There should be an implicit index created on the primary key (id
). How can I see that index?
SELECT * FROM all_indexes WHERE table_name = 'temp';
gives
no rows selected