RE: How can I tell if an index is a function-based index/
Jack, Thanks for your helpful reply. Looks like my index is not function-based. Darn! Now I don't know why I'm getting this error and Metalink won't let me in to update my TAR. Cherie
RE: How can I tell if an index is a function-based index/
Cherie, Yes funcidx_status will be ENABLED and there'll be a row in User_Ind_Expressions for each function-based index. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED]