Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: disable pk works differently in oracle 9 and oracle 10?

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

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 8 Jun 2006 15:46:19 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF27083E3D82@AABO-EXCHANGE02.bos.il.pqe>


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
Received on Thu Jun 08 2006 - 14:46:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US