4 Replies Latest reply on Jun 1, 2009 4:05 PM by 704468

    Adding another column to a primary key

      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.