Getting indexes from table 1

[Zargo]

Hi all,

How can we get (in a SQL statement) all indexes on a table?

IN SQL server we could do this with a stored procedure called sp_helpindex(sp_helpindex tablename) how to do this in Oracle?

TIA

 

[djbjr]

Try this

select index_name
from all_indexes
where table_name = (INSERT YOUR TABLE_NAME HERE)
and owner = (INSERT SCHEMA NAME HERE)


Is this what you are looking for?

 

[Zargo]

HMM, It sounds good i have tried

select index_name
from all_indexes
where OWNER = "USERA"

But i'm getting an ORA-00904 eror (invalid identifier) on the "USERA" statement. The user exists and there are some tables witch has indexes..

Any idea?

 

[BJCooperIT]

Use single quotes, not double quotes:

select index_name 
from all_indexes 
where OWNER = 'USERA'

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[djbjr]

Are you using double quotes?

Try using single quotes if you are.

 

[Zargo]

Oops indeed...Thanks all