cybotto_at_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_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 13 2005 - 11:14:32 CDT
