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

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: "Alex Gorbachev" <gorbyx@xxxxxxxxx>, <genegurevich@xxxxxxxxxxxxxxxxxxxxx>
  • Date: Thu, 8 Jun 2006 15:46:19 -0400

Yep, I checked for that. 


--
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


-----Original Message-----
From: Alex Gorbachev [mailto:gorbyx@xxxxxxxxx] 
Sent: Thursday, June 08, 2006 3:46 PM
To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
Cc: Schultz, Charles; Bobak, Mark; oracle-l; erichjenkinson@xxxxxxxxx
Subject: Re: disable pk works differently in oracle 9 and oracle 10?

Is index still valid after disabling constraint?

2006/6/8, genegurevich@xxxxxxxxxxxxxxxxxxxxx
<genegurevich@xxxxxxxxxxxxxxxxxxxxx>:
> Charles, Mark and Erich
>
> Thank you for your help.
>
> Charles, thanks for the reference to the 139666.1 note. My case is 
> close to the case 3, but not exactly because I build a unique index 
> (and in the Note the index built as a nonunique which makes a 
> difference according to Mark's Email).
> so I have opened a SR with Oracle and will hope to get some definite 
> answer from them. Erich, my case seems to contradict the info you have

> found in the  admin guide. So may be I have done something incorrectly

> . I'll post whatever answer I will get from oracle
>
> thank you
>
> Gene Gurevich
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
Best regards,
Alex Gorbachev

http://oracloid.blogspot.com
--
//www.freelists.org/webpage/oracle-l


Other related posts: