Re: What should I notice when I drop an index and recreate it.

From: Gillian M <zmkj04_at_yahoo.com>
Date: Fri, 24 Nov 2000 11:01:44 -0800 (PST)
Message-Id: <10690.122866@fatcity.com>

Yes, once a package was create, referring to a particular index, then you need to
re-create/re-compile that package after messing with the index.

If you have Designer or OEM, there are tools, that can give dependencies.

You should also watch out for foreign keys. If the index is a primary key, and a foreign key references that primary key, then you need to disable the FK, else Oracle would not let you mess with the index.

G!

• Chuan Zhang <chuan_at_asiaonline.net> wrote: > Hi,
  >
  > Recently, I drop an index and recreate that index
  > in different type. Some of the packages became
  > INVALID.
  > As I know, in Oracle, you can drop and alter an
  > index at any time. Oracle recommends that you should
  > notice the performance. I have no idea why this
  > recreating index cause the package being INVALID.
  > One thing I am not sure is that maybe some packages
  > are particularly specified to use that dropped
  > index, thus cause the package invalidated.
  >
  >
  > What should I watch out when I recreating Indexes?
  >
  > Many Thanks for any help
  >
  > Chuan
  >
  >
  >
  

  ---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Fri Nov 24 2000 - 13:01:44 CST