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

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_at_gmail.com] 
Sent: Thursday, June 08, 2006 3:46 PM
To: genegurevich_at_discoverfinancial.com
Cc: Schultz, Charles; Bobak, Mark; oracle-l; erichjenkinson_at_gmail.com
Subject: Re: disable pk works differently in oracle 9 and oracle 10?

Is index still valid after disabling constraint?

2006/6/8, genegurevich_at_discoverfinancial.com
<genegurevich_at_discoverfinancial.com>:


> 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

>

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>



--
Best regards,
Alex Gorbachev

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