ALTER TABLE MBH.SURVEY_ITEMS_SP DROP PRIMARY KEY CASCADE; DROP TABLE MBH.SURVEY_ITEMS_SP CASCADE CONSTRAINTS; CREATE TABLE MBH.SURVEY_ITEMS_SP ( SITEMID NUMBER(10) NOT NULL, SITEMTITLE VARCHAR2(200 CHAR) NOT NULL, SID NUMBER(10) NOT NULL, SITEMORDER NUMBER(10) NOT NULL, SITEMCOUNT NUMBER(10) NOT NULL ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; CREATE UNIQUE INDEX MBH.PRIMARY_3 ON MBH.SURVEY_ITEMS_SP (SITEMID) LOGGING TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) NOPARALLEL; ALTER TABLE MBH.SURVEY_ITEMS_SP ADD ( CONSTRAINT PRIMARY_3 PRIMARY KEY (SITEMID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ));