RE: disable pk works differently in oracle 9 and oracle 10?

 


________________________________

>From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Connor McDonald
>Sent: Friday, June 09, 2006 12:59 AM
>To: gogala@xxxxxxxxxxxxx
>Cc: genegurevich@xxxxxxxxxxxxxxxxxxxxx; oracle-l
>Subject: Re: disable pk works differently in oracle 9 and oracle 10?




 > I have to admit I like the new default...now if only I could set a
unique index to unusable I'd be a happy camper


 
 
Connor, you may not be able to mark a unique index unusable, but you can
get around that by making the index non-unique.  I've used this
technique before.
 
Create non-unique index, add unique constraint (which will utilize
non-unique index), then, when I want to, I can disable constraint, mark
index unusable, do data load, rebuild index nologging, and enable
constraint.
 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled.  --Richard P. Feynman, 1918-1988

 

Other related posts: