Excellent point, Alfonso. And, it makes a certain amount of sense. -- 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: Alfonso León [mailto:aleon68@xxxxxxxxx] Sent: Thursday, June 08, 2006 5:36 PM To: Bobak, Mark Cc: Alex Gorbachev; genegurevich@xxxxxxxxxxxxxxxxxxxxx; Schultz, Charles; oracle-l; erichjenkinson@xxxxxxxxx Subject: Re: disable pk works differently in oracle 9 and oracle 10? I create the primary key and let the database create the index, then disable the primary key and the index was gone. Then I drop the PK, create the unique index and create the PK with the existing index. When I disable the PK the index remains. So it is clear that if you create the index before the PK then the index will be respected as a prior object and will not be dropped On 6/8/06, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote: > 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 > > > -- Alfonso Leon -- //www.freelists.org/webpage/oracle-l