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

Home -> Community -> Usenet -> c.d.o.server -> Re: Test if Data for a Field is UNIQUE

Re: Test if Data for a Field is UNIQUE

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 24 Jan 2006 03:13:52 GMT
Message-Id: <pan.2006.01.24.03.13.52.221413@sbcglobal.net> 





On Mon, 23 Jan 2006 16:57:36 -0500, Walt wrote:



> Well, yes and no.  In theory it is possible to have a unique constraint 

> without an index.




Walt, it is possible to create a non-unique index and then create a
unique or PK constraint with "enable novalidate" option. It will work.
Existing duplicate data will be tolerated, but you will not be able to 
enter new duplicate rows.


-- 
http://www.mgogala.com


Received on Mon Jan 23 2006 - 21:13:52 CST












Original text of this message













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