troubleshooting Question

Oracle change Primary Key Constraint

Avatar of Nakuru1234
Nakuru1234 asked on
Oracle Database
35 Comments1 Solution2618 ViewsLast Modified:
Hello,

I created the following table but I need to alter the table and change the primary key constraint. I presently have one PK on PARAM_ID and I need to add another PK on the column CIR_TYPE. How can I accomplish that? Thanks for your help.

CREATE TABLE UTG.PARAMETER
(
  PARAM_ID         VARCHAR2(31 BYTE) CONSTRAINT NN_PARAM_PARAMID NOT NULL,
  LABEL            VARCHAR2(31 BYTE),
  TYPE             VARCHAR2(10 BYTE),
  VALUE            VARCHAR2(128 BYTE),
  MIN_LENGTH       NUMBER(4),
  MAX_LENGTH       NUMBER(4),
  VALID_SELECTION  VARCHAR2(512 BYTE),
  FORMAT           VARCHAR2(20 BYTE),
  CIR_TYPE         VARCHAR2(16 BYTE),
  DESCRIP          VARCHAR2(128 BYTE),
  ENABLED          VARCHAR2(10 BYTE)
)

TIA,
N
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 35 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 35 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros