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's
> a 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 01752
>
> Together: the Collaborative Business Experience
> ______________________________________________________________
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 14 2007 - 10:57:33 CDT
