| No Format |
|---|
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 |