| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> What should I notice when I drop an index and recreate it.
This is a multi-part message in MIME format.
------=_NextPart_000_01BA_01C0561F.8A843930 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
------=_NextPart_000_01BA_01C0561F.8A843930 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2> Recently, I drop an index =
and recreate=20
that index in different type. Some of the packages became =
INVALID.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>As I know, in Oracle, you can drop and =
alter an=20
index at any time. Oracle recommends that you should notice the=20
performance. I have no idea why this recreating index cause the =
package=20
being INVALID. One thing I am not sure is that maybe some packages are=20
particularly specified to use that dropped index, thus cause the package =
invalidated.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>What should I watch out when I =
recreating=20
Indexes?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Many Thanks for any help</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Chuan</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
Received on Thu Nov 23 2000 - 21:05:03 CST
 |
 |