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!

Adding another column to a primary key

704468Jun 1 2009 — edited Jun 1 2009

I am an SQL Server and DB2 DBA and have no clue about the Oracle. However, we end up having a client who use Oracle database and a question came as how an additional column can be added to a selected primary key columns. The current primary key consist of 2 columns and another column needed to be included in the primary key. What is the best way to do this. Can it be done by PL/SQL code ?. Anything special need to be done ?. Sorry, I don't have the Oracle version nor the OS info.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2009

Added on Jun 1 2009

#general-database-discussions

4 comments

3,796 views