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

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

Recreating Scripts - Something to worry about ???

From: Weerd Kirsten, E.C. de <Kirsten.deWeerd_at_Oranjewoud.nl>
Date: Tue, 5 Dec 2000 12:44:04 +0100
Message-Id: <10701.123634@fatcity.com> 





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,
Received on Tue Dec 05 2000 - 05:44:04 CST












Original text of this message













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