ALTER TABLE MBH.SURVEY_SP DROP PRIMARY KEY CASCADE; DROP TABLE MBH.SURVEY_SP CASCADE CONSTRAINTS; CREATE TABLE MBH.SURVEY_SP ( SID NUMBER(10) NOT NULL, STITLE VARCHAR2(200 CHAR) NOT NULL, SPOLLTYPE VARCHAR2(50 CHAR), SCHOICETYPE NUMBER(10) ) 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_2 ON MBH.SURVEY_SP (SID) 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_SP ADD ( CONSTRAINT PRIMARY_2 PRIMARY KEY (SID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ));