QUERY – Index table

Query que saca los indices que contiene una tabla.

/*
OWNER                          TABLE_NAME                     INDEX_NAME      PAR
------------------------------ ------------------------------ --------------- ---
UEORA0                         UETWCEAO                       UETWCEAO_PK     NO
*/

BREAK ON OWNER ON TABLE_NAME SKIP 1
SELECT OWNER, TABLE_NAME, INDEX_NAME,PARTITIONED 
FROM DBA_INDEXES 
WHERE OWNER LIKE '%&owner%' 
 AND TABLE_NAME LIKE '%&table_name%' ORDER BY OWNER,TABLE_NAME;