Re: changing a non-unique index to unique index

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sat, 20 Mar 2004 07:19:34 -0500
Message-ID: <uuednQmTy5xyq8HdRVn-ig@comcast.com>

"fareeda" <fareeda_at_pspl.co.in> wrote in message news:c6d78d84.0403200349.72d5a913_at_posting.google.com...
| is there a way to change a non-unique index to a unique index (other
| than dropping and re-creating it)?
| regards

if possible, it would have to be done with an ALTER INDEX statement and you'll not find any such option if you check the Oracle SQL Reference (as of 9i R2)

are you sure you need to change it to unique? if you add a unique constraint it can use the existing non-unique index, and preserve the option of (temporarily) disabling the constraint without dropping the index

;-{ mcs Received on Sat Mar 20 2004 - 06:19:34 CST