Just curious... anyone experienced corrupted indexes with the "rebuild
online" option? On Metalink there is an alert about this which affects
all 8i versions, Note: 125149.1
Gary Weber wrote:
>
> If you're on 8i, do look into "rebuild online" functionality. I think the
> "online" came about in 8i, but could've been born with 8...
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Weerd
> > Kirsten, E.C. de
> > Sent: Tuesday, December 05, 2000 6:46 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Recreating Scripts - Something to worry about ???
> >
> >
> > Hi,
> >
> > I asked for a script, and have recevied several for which I thank
> > you all, for automatically recreating indexes.
> >
> > One thing I'm wondering about B4 I try it all out :
> >
> > When a table is created with a PK or Uniqe-constraint, indexes are
> > created, right ??? But if I drop these indexes en recreate them, is the
> > PK/U-constraint still valid, or do these indexe shave to be
> > filtered out of
> > the mass ???
> >
> > Greets,
> >
> > Kirsten
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Weerd Kirsten, E.C. de
> > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gary Weber
> INET: gweber_at_cji.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Dec 08 2000 - 21:20:39 CST
