Drop Unique Key and generate new unique key
CREATE TABLE wsc_widget_bundle (
    id VARCHAR (50),
    widgetBundle BLOB NULL,
    devicesoftwareclass VARCHAR(30) NOT NULL,
    widgetProfileId VARCHAR (50) NOT NULL,
    bundleHash BLOB NULL,
    widgetLocale VARCHAR (6) NOT NULL ,
    status INT,
        primary key(id),
        unique(widgetProfileId, devicesoftwareclass,status),
    foreign key(widgetProfileId) references wsc_widget_profile(id)
  );

create table "MTP440_DEV1"."WSC_WIDGET_BUNDLE"(
    "ID" VARCHAR2(50) not null,
   "WIDGETBUNDLE" BLOB,
   "DEVICESOFTWARECLASS" VARCHAR2(30) not null,
   "WIDGETPROFILEID" VARCHAR2(50) not null,
   "BUNDLEHASH" BLOB,
   "WIDGETLOCALE" VARCHAR2(6) not null,
   "STATUS" NUMBER,
    constraint "SYS_C00323290" primary key ("ID")
);

alter table "MTP440_DEV1"."WSC_WIDGET_BUNDLE"
    add constraint "SYS_C00323292"
    foreign key ("WIDGETPROFILEID")
    references "MTP440_DEV1"."WSC_WIDGET_PROFILE"("ID");
create unique index "MTP440_DEV1"."SYS_C00323290" on "MTP440_DEV1"."WSC_WIDGET_BUNDLE"("ID");
create unique index "MTP440_DEV1"."SYS_C00323291" on "MTP440_DEV1"."WSC_WIDGET_BUNDLE"("WIDGETPROFILEID","DEVICESOFTWARECLASS","STATUS");
create index "MTP440_DEV1"."TEST" on "MTP440_DEV1"."WSC_WIDGET_BUNDLE"("DEVICESOFTWARECLASS","STATUS","WIDGETLOCALE","WIDGETPROFILEID");

Alter table x
drop constraint pk;

Alter table x
add constraint New_constraint_name PRIMARY KEY (colname);