CREATE TABLE SAKAI_EXTERNAL.BANNER_GRADINGSCHEME (
CODE VARCHAR2(3) NOT NULL,
DESCRIPTION VARCHAR2(90) NULL,
CREATEDBY CHAR(6) NULL,
CREATEDDATE DATE NOT NULL,
LASTMODIFIEDBY CHAR(6) NULL,
LASTMODIFIEDDATE DATE NOT NULL,
CONSTRAINT PK_STVGMOD1 PRIMARY KEY(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
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_GRADINGSCHEME TO SAKAI_EXTERNAL_SELECT
GO