ALTER TABLE MBH.TRANSFORMS_SP DROP PRIMARY KEY CASCADE; DROP TABLE MBH.TRANSFORMS_SP CASCADE CONSTRAINTS; CREATE TABLE MBH.TRANSFORMS_SP ( FILE_ID NUMBER(10) NOT NULL, FILE_NAME VARCHAR2(100 BYTE), XSLT_FILE BLOB ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS LOB (XSLT_FILE) STORE AS ( TABLESPACE USERS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE INDEX ( TABLESPACE USERS STORAGE ( INITIAL 64K NEXT 1 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) ) NOCACHE NOPARALLEL MONITORING; CREATE UNIQUE INDEX MBH.TRANSFORMS_PK ON MBH.TRANSFORMS_SP (FILE_ID) 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.TRANSFORMS_SP ADD ( CONSTRAINT TRANSFORMS_PK PRIMARY KEY (FILE_ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ));