Actually later I tested functional index with synonym, view. Instead of using table directly in the procedure, I used synonym and view, but when dropping functional index, still will cause package object invalid. But my test show when you only drop a normal index, it will not invalidate the package
1 comment:
Actually later I tested functional index with synonym, view. Instead of using table directly in the procedure, I used synonym and view, but when dropping functional index, still will cause package object invalid.
But my test show when you only drop a normal index, it will not invalidate the package
Post a Comment