Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recreating Scripts - Something to worry about ???

Re: Recreating Scripts - Something to worry about ???

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Fri, 08 Dec 2000 23:33:32 -0500
Message-Id: <10704.124134@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US