DBA Data[Home] [Help]

APPS.ETRM_RPT dependencies on DBA_INDEXES

Line 208: cursor cur_index(cv_tab_name in dba_indexes.table_name%type

204: and table_name = c_name
205: and (table_type = 'TABLE'
206: OR table_type = 'VIEW');
207:
208: cursor cur_index(cv_tab_name in dba_indexes.table_name%type
209: , c_owner in dba_objects.owner%type)
210: -- List Indexes
211: is select ind.index_name
212: , ind.uniqueness

Line 217: from dba_indexes ind

213: , ind.tablespace_name
214: , ind.pct_increase
215: , ind.pct_free
216: , ind.owner
217: from dba_indexes ind
218: where ind.table_name = cv_tab_name
219: and ind.table_owner = c_owner
220: order by ind.uniqueness desc, ind.index_name;
221: --