Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: pros and cons
Hmm...so many new features here and there...impossible to keep up! ;-)
Thanks Richard!
-----Original Message-----
From: Richard Foote [mailto:richard.foote_at_bigpond.com]
Sent: Wednesday, March 31, 2004 7:44 AM
To: oracle-l_at_freelists.org
Subject: Re: pros and cons
Hi Mark,
The index doesn't have to be dropped if you use the KEEP INDEX option (9i).
Cheers
Richard
From: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, March 31, 2004 10:41 AM
Subject: RE: pros and cons
No gotchas that I'm aware of.
I look at it as an adavantage, because when you're doing table maintenance, you can disable the PK/UK constraint, and the corresponding index won't be dropped. In the case of a unique index, any time you diable the corresponding constraint, the index will be dropped. (It has to be, else the column would still have the unique property, due to the index.)
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |