| < Day Day Up > |
|
set wrap off linesize 132 pages 80; column pos format 990; column col format a10; column ind format a25; column tab format a25; column typ format a20; column tbs format a25; select t.table_name "Tab" ,decode(t.index_type,'NORMAL','BTree','BITMAP','Bitmap' ,'FUNCTION-BASED NORMAL','Function-Based BTree' ,t.index_type) "Typ" ,t.index_name "Ind", c.column_name "Col", c.column_position "Pos" ,t.tablespace_name "Tbs" from user_indexes t, user_ind_columns c where t.table_name = c.table_name and t.index_name = c.index_name and t.index_type not in ('IOT – TOP','LOB') order by t.table_name, t.index_name, c.column_position;
| < Day Day Up > |
|