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: How to insert data using index unusable/rebuild

Re: How to insert data using index unusable/rebuild

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Fri, 11 Jul 2003 22:09:10 +0200
Message-ID: <766ugvsv17igp4al96pjgc3lubqvjm8aud@4ax.com> 





On 11 Jul 2003 09:49:43 -0700, JusungYang_at_yahoo.com (Jusung Yang)
wrote:


...


> - since primary

>keys do not have to be unique.



 ..



By which is meant: an index underlying and enforcing a primary key
constraint doesnot have to be unique (from Oracle 8 onward). Just
specify an nonunique index first and then the primary key on the same
columns.



Jaap.
Received on Fri Jul 11 2003 - 15:09:10 CDT












Original text of this message













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