Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Secondary Primary Key

GQJun 12 2007 — edited Jun 12 2007
Hi All,

I have already created one Primary Key against one column like col4 of the table in Oracle 9i. I want to create a secondary primary key against three columns like col1, col2, col3. Is it allowed in Oracle to create secondary primary key or I need to create secondary key only. Could any body please help with solution/example?

Many thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2007
Added on Jun 12 2007
2 comments
223 views