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