modify primary key

#1

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.

#2

Prasath wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

modify primary key

comp.databases.oracle.misc comp.databases.oracle.misc

modify primary key - 10-31-2006 , 11:45 AM

Re: modify primary key - 11-07-2006 , 05:31 AM