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

If you try to drop the index using 'DROP INDEX ...' you will get an error if the index is referenced by a primary /unique constraint ... try and you will see:

SQL> drop index A_VTF_PK;
drop index A_VTF_PK
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key

HTH, Remco

> ----------
> From: Weerd Kirsten, E.C. de[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Sent: dinsdag 5 december 2000 12:45
> 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).
Received on Tue Dec 05 2000 - 06:40:04 CST