ALTER TABLE MBH.VIDEOS_SP DROP PRIMARY KEY CASCADE; DROP TABLE MBH.VIDEOS_SP CASCADE CONSTRAINTS; CREATE TABLE MBH.VIDEOS_SP ( VID NUMBER(10) NOT NULL, VTHUMB VARCHAR2(200 CHAR) NOT NULL, VSWF VARCHAR2(200 CHAR) NOT NULL, VTITLE VARCHAR2(200 CHAR) NOT NULL, CID NUMBER(10) NOT NULL, VFEATURING VARCHAR2(200 CHAR), VISDEFAULT NUMBER(3) ) 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_4 ON MBH.VIDEOS_SP (VID) 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.VIDEOS_SP ADD ( CONSTRAINT PRIMARY_4 PRIMARY KEY (VID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ));