/
BANNER_MEETING
BANNER_MEETING
CREATE TABLE SAKAI_EXTERNAL.BANNER_MEETING ( EID VARCHAR2(181) NULL, SECTION_EID VARCHAR2(91) NULL, STARTTIME TIMESTAMP(9) NULL, ENDTIME TIMESTAMP(9) NULL, LOCATION VARCHAR2(49) NULL, SUNDAY VARCHAR2(3) NULL, MONDAY VARCHAR2(3) NULL, TUESDAY VARCHAR2(3) NULL, WEDNESDAY VARCHAR2(3) NULL, THURSDAY VARCHAR2(3) NULL, FRIDAY VARCHAR2(3) NULL, SATURDAY VARCHAR2(3) NULL, NOTES VARCHAR2(255) NULL, CREATEDBY CHAR(6) NULL, CREATEDDATE DATE NOT NULL, LASTMODIFIEDBY CHAR(6) NULL, LASTMODIFIEDDATE DATE NOT NULL ) TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE( INITIAL 19922944 MINEXTENTS 1 MAXEXTENTS 2147483645 ) PARALLEL( DEGREE 1 ) LOGGING NOCACHE MONITORING GO CREATE INDEX SAKAI_EXTERNAL.BANNER_MEETING_PIDX ON SAKAI_EXTERNAL.BANNER_MEETING(SECTION_EID, STARTTIME, ENDTIME, LOCATION) TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE( INITIAL 24117248 MINEXTENTS 1 MAXEXTENTS 2147483645 ) PARALLEL( DEGREE 1 ) LOGGING GO GRANT SELECT ON SAKAI_EXTERNAL.BANNER_MEETING TO SAKAI_EXTERNAL_SELECT GO