Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recreating Scripts - Something to worry about ???
been playing with 8i since it came out on solaris and linux, aint see
one yet. seen quite a few of the other bugs but not that one. on all
platforms or specific?
joe
Suzy Vordos wrote:
>
> 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
> > > --
>
>
-- Joe Testa http://www.oracle-dba.com No you can't fix an ORA-600 error, call Oracle Support.Received on Fri Dec 08 2000 - 22:33:32 CST
![]() |
![]() |