CREATE TABLE SAKAI_EXTERNAL.BANNER_ACADEMICSESSION (
EID VARCHAR2(60) NULL,
TITLE VARCHAR2(90) NOT NULL,
DESCRIPTION VARCHAR2(17) NULL,
STARTDATE DATE NOT NULL,
ENDDATE DATE NOT NULL,
CREATEDBY CHAR(6) NULL,
CREATEDDATE DATE NOT NULL,
LASTMODIFIEDBY CHAR(6) NULL,
LASTMODIFIEDDATE DATE NOT NULL,
TERM_CODE VARCHAR2(18) NOT NULL,
CONSTRAINT PK_STVTERM1 PRIMARY KEY(TERM_CODE)
USING INDEX
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 )
LOGGING
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
NOCACHE
MONITORING
GO