CREATE TABLE SAKAI_EXTERNAL.BANNER_CANONICALCOURSE (
EID VARCHAR2(64) NULL,
TITLE VARCHAR2(28) NULL,
DESCRIPTION VARCHAR2(28) NULL,
CREATEDBY CHAR(6) NULL,
CREATEDDATE DATE NULL,
LASTMODIFIEDBY CHAR(6) NULL,
LASTMODIFIEDDATE DATE NULL
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 3145728 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
NOCACHE
MONITORING
GO
CREATE UNIQUE INDEX SAKAI_EXTERNAL.BANNER_CANONICALCOURSE_PIDX
ON SAKAI_EXTERNAL.BANNER_CANONICALCOURSE(EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 2097152 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_CANONICALCOURSE TO SAKAI_EXTERNAL_SELECT
GO