I recall a similar situation where the function part of the FBI was a query accessing data in another table and building an index based on that data. Changes to the referenced table (not the indexed one) caused the FBI to go invalid.
-- Daniel Fink Oracle Performance, Diagnosis and Training OptimalDBA http://www.optimaldba.com Oracle Blog http://optimaldba.blogspot.com Join me at Miracle Scotland DB Forum! http://www.miracleltd.com/index.asp?page=167&page2=343 Richard J. Goulet wrote:
AH, another missing piece of the puzzle, we're talking about function based indexes. Well if the function that was used to create the index was rebuilt/modified that would explain everything. Especially if it'sa non oracle provided function.______________________________________________________________ Dick Goulet / Capgemini North America P&C / East Business Unit \Senior Oracle DBA / Outsourcing Office: 508.572.1978 / Mobile: 508.742.5795 / www.capgemini.com Fax: 508.229.2019 45 Bartlett St. / Marlborough, MA 01752Together: the Collaborative Business Experience ______________________________________________________________
-- //www.freelists.org/webpage/oracle-l