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).
Received on Tue Dec 05 2000 - 08:17:45 CST
