Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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
  • No labels