表的script
CREATE TABLE EMAILRECVMSG
(
MAILID CHAR(20) NOT NULL,
TOTALSIZE INTEGER,
CONTENT BLOB
)
TABLESPACE RECMSG_DATA
PCTUSED 40
PCTFREE 10
INITRANS 5
MAXTRANS 255
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 20
FREELIST GROUPS 4
BUFFER_POOL DEFAULT
)
LOGGING
LOB (CONTENT) STORE AS
( TABLESPACE RECMSG_LOB
DISABLE STORAGE IN ROW
CHUNK 8192
PCTVERSION 10
CACHE
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 20
FREELIST GROUPS 4
BUFFER_POOL DEFAULT
)
)
NOCACHE
PARALLEL ( DEGREE 4 INSTANCES 1 );
CREATE UNIQUE INDEX PK_EMAILRECVMSG_MAILID ON EMAILRECVMSG
(MAILID)
LOGGING
TABLESPACE RECMSG_INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 20
FREELIST GROUPS 4
BUFFER_POOL DEFAULT
)
NOPARALLEL;
ALTER TABLE EMAILRECVMSG ADD (
CONSTRAINT PK_EMAILRECVMSG_MAILID PRIMARY KEY (MAILID)
USING INDEX
TABLESPACE RECMSG_INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 20
FREELIST GROUPS 4
));
GRANT SELECT ON EMAILRECVMSG TO MTAMANAGER;