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

Alfonso, what version of the database are you using? 9 or 10?

thank you

Gene Gurevich
Oracle Engineering
224-405-4079

                                                                           
             "Alfonso León"                                                
             <aleon68_at_gmail.co                                             
             m>                                                         To 
                                       Mark.Bobak_at_il.proquest.com          
             06/08/2006 04:35                                           cc 
             PM                        "Alex Gorbachev"                    
                                       <gorbyx_at_gmail.com>,                 
                                       genegurevich_at_discoverfinancial.com, 
                                       "Schultz, Charles"                  
                                       <sac_at_uillinois.edu>, oracle-l       
                                       <oracle-l_at_freelists.org>,           
                                       erichjenkinson_at_gmail.com            
                                                                   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_at_il.proquest.com> 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_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
>
>
>

--
Alfonso Leon




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