disable pk works differently in oracle 9 and oracle 10? 2006-06-08 - By genegurevich@(protected)
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@(protected)
m> To
Mark.Bobak@(protected)
06/08/2006 04:35 cc
PM "Alex Gorbachev"
<gorbyx@(protected)>,
genegurevich@(protected),
"Schultz, Charles"
<sac@(protected)>, oracle-l
<oracle-l@(protected)>,
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
|
|
