Hi, Which dictionary view show function based index column name and function used at time of creation of function based indexes. dba_ind_columns show only SYS_NCxxxxxx. thanks -Seema _________________________________________________________________ Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- //www.freelists.org/webpage/oracle-l