RE: How can I tell if an index is a function-based index/

2001-04-04 Thread Cherie_Machler
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/

2001-04-04 Thread Jack C. Applewhite
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]