Re: disable pk works differently in oracle 9 and oracle 10?
- From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- To: "Alfonso León" <aleon68@xxxxxxxxx>
- Date: Thu, 8 Jun 2006 17:04:55 -0500
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@xxxxxxxx
m> To
Mark.Bobak@xxxxxxxxxxxxxxx
06/08/2006 04:35 cc
PM "Alex Gorbachev"
<gorbyx@xxxxxxxxx>,
genegurevich@xxxxxxxxxxxxxxxxxxxxx,
"Schultz, Charles"
<sac@xxxxxxxxxxxxx>, oracle-l
<oracle-l@xxxxxxxxxxxxx>,
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
Other related posts:
