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

Home -> Community -> Usenet -> c.d.o.misc -> modify primary key

modify primary key

From: Prasath <prasath.rao_at_gmail.com>
Date: 31 Oct 2006 09:45:30 -0800
Message-ID: <1162316730.587146.43680@e64g2000cwd.googlegroups.com>


How do I add a existing column to a composite key in an index organized table on Oracle 9i?

create table mytable (
mycol1 number,
mycol2 number.
mycol3 number
constraint myconstraint primary key(mycol1, mycol2) ) organization index;

now i need to add mycol3 to the primary key. Received on Tue Oct 31 2006 - 11:45:30 CST

Original text of this message

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