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@(protected)] Sent: Thursday, June 08, 2006 5:36 PM To: Bobak, Mark Cc: Alex Gorbachev; genegurevich@(protected); Schultz, Charles; oracle-l; erichjenkinson@(protected) 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@(protected)> 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@(protected)] > Sent: Thursday, June 08, 2006 3:46 PM > To: genegurevich@(protected) > Cc: Schultz, Charles; Bobak, Mark; oracle-l; erichjenkinson@(protected) > Subject: Re: disable pk works differently in oracle 9 and oracle 10? > > Is index still valid after disabling constraint? > > 2006/6/8, genegurevich@(protected) > <genegurevich@(protected)>: > > 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 > > >
-- Alfonso Leon -- http://www.freelists.org/webpage/oracle-l
