DBA Data[Home] [Help]

APPS.AS_UTILITY_PVT dependencies on DBA_IND_COLUMNS

Line 876: FROM dba_ind_columns col, dba_indexes ind

872: ceil(ind.initial_extent/1048576) intext, ceil(nvl(ind.next_extent/1048576,1)) nextext,
873: ind.min_extents minext, ind.max_extents maxext, nvl(ind.pct_increase,0) pct,
874: nvl(ind.ini_trans,1) ini_trans, nvl(ind.max_trans,255) max_trans,
875: nvl(ind.pct_free,20) pct_free, nvl(ind.freelists,1) freelists, ind.tablespace_name ts, ind.degree
876: FROM dba_ind_columns col, dba_indexes ind
877: WHERE ind.table_owner = p_tbl_owner
878: AND ind.table_name = p_tbl_name
879: AND ind.index_type = 'NORMAL'
880: AND col.index_owner = ind.owner