FA Database Index Listing - draft

Description
Categories: BI Publisher
Application: Assets
Source: Database Index Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FASINDX_XML
DB package: FA_FASINDX_XMLP_PKG
select	ind.table_name,
	ind.index_name,
	obj.created,
	obj.last_ddl_time,
	lu.meaning	unique_flag,
	col.column_name
from	all_indexes ind,
	all_ind_columns col,
	all_objects obj,
	fa_lookups lu
where	ind.table_name like 'FA%'
and	col.table_name = ind.table_name
and	col.index_name = ind.index_name
and	obj.object_name = ind.index_name
and	obj.object_type = 'INDEX'
and	lu.lookup_type = 'YESNO'
and	lu.lookup_code = decode (ind.uniqueness, 'UNIQUE', 'YES', 'NO')
order by
	ind.table_name, ind.index_name, col.column_position
Ask a question