DBA Data[Home] [Help]

APPS.AS_UTILITY_PVT dependencies on DBA_IND_EXPRESSIONS

Line 892: FROM dba_ind_expressions exp, dba_indexes ind

888: ceil(ind.initial_extent/1048576) intext, ceil(nvl(ind.next_extent/1048576,1)) nextext,
889: ind.min_extents minext, ind.max_extents maxext, nvl(ind.pct_increase,0) pct,
890: nvl(ind.ini_trans,1) ini_trans, nvl(ind.max_trans,255) max_trans,
891: nvl(ind.pct_free,20) pct_free, nvl(ind.freelists,1) freelists, ind.tablespace_name ts, ind.degree
892: FROM dba_ind_expressions exp, dba_indexes ind
893: WHERE ind.table_owner = p_tbl_owner
894: AND ind.table_name = p_tbl_name
895: AND ind.index_type = 'FUNCTION-BASED NORMAL'
896: AND exp.index_owner = ind.owner