cybotto@yahoo.com wrote:
> If you recompile a function which makes the function based index it
> will invalidate that index. With source control that is a tricky bit,
> since every time is compiling is invalidating that index even when
> nothing changed in the code.
>
> Best is to drop and recreate it again, rebuilding it can cause some
> other issues.

Or use $ORACLE_HOME/rdbms/admin/utlrp.sql
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)