SQL & PL/SQL

  ALTER SESSION FORCE PARALLEL DDL PARALLEL 128;

  CREATE TABLE "SERVICECONFIGURATIONITEM"

   (    

    "NAME" VARCHAR2(255 BYTE),

    "VALUE" VARCHAR2(255 BYTE),

    "ENTITYID" NUMBER(19,0)

    CONSTRAINT "PK_SCVI" PRIMARY KEY ("ENTITYID")

    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING

    ENABLE NOVALIDATE,

    CONSTRAINT "SRVICECONFIGURATIONITEMNTITYID" FOREIGN KEY ("ENTITYID")

    REFERENCES "BUSINESSINTERACTIONITEM" ("ENTITYID") DEFERRABLE INITIALLY DEFERRED ENABLE NOVALIDATE,

    )

  CREATE TABLE "BUSINESSINTERACTIONITEM"

   (    "ENTITYID" NUMBER(19,0) NOT NULL ENABLE,

     PRIMARY KEY ("ENTITYID")

   );   

CREATE TABLE SCVI_TEMP

    (   

    "NAME" VARCHAR2(255 BYTE),

    "VALUE" VARCHAR2(255 BYTE),

    "ENTITYID" NUMBER(19,0),

    )   

    nologging AS

    select * from SERVICECONFIGURATIONITEM;

ALTER TABLE SERVICECONFIGURATIONITEM RENAME TO SERVICECONFIGURATIONITEM_CII;

ALTER TABLE SCVI_TEMP RENAME TO SERVICECONFIGURATIONITEM;

alter table "SERVICECONFIGURATIONITEM_CII" drop constraint "PK_SCVI"; 

ALTER TABLE ServiceConfigurationItem_CII DROP CONSTRAINT SrviceConfigurationItemNTITYID ;   

ALTER TABLE ServiceConfigurationItem ADD CONSTRAINT SrviceConfigurationItemNTITYID FOREIGN KEY (ENTITYID) REFERENCES BusinessInteractionItem (ENTITYID) INITIALLY DEFERRED DEFERRABLE ENABLE NOVALIDATE  NOLOGGING;

CREATE UNIQUE INDEX IDX_PK_SCVI ON SERVICECONFIGURATIONITEM(ENTITYID) NOLOGGING;

ALTER TABLE SERVICECONFIGURATIONITEM ADD CONSTRAINT PK_SCVI PRIMARY KEY (ENTITYID) USING INDEX IDX_PK_SCVI NOVALIDATE;

ALTER TABLE SERVICECONFIGURATIONITEM ENABLE VALIDATE CONSTRAINT PK_SCVI;

ALTER TABLE ServiceConfigurationItem ENABLE VALIDATE CONSTRAINT SrviceConfigurationItemNTITYID;   

ALTER SESSION DISABLE PARALLEL DDL;