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_at_gmail.com]
Sent: Thursday, June 08, 2006 5:36 PM
To: Bobak, Mark
Cc: Alex Gorbachev; genegurevich_at_discoverfinancial.com; Schultz, Charles; oracle-l; 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
Received on Thu Jun 08 2006 - 16:37:57 CDT
