BANNER_OFFERING_COURSESETS

Owned by Thomas Amsler
Last updated: Sept 22, 2007Version comment
1 min read
CREATE TABLE SAKAI_EXTERNAL.BANNER_OFFERING_COURSESETS ( 
    COURSEOFFERING_EID	VARCHAR2(82) NULL,
    COURSESET_EID     	VARCHAR2(59) NULL 
    )
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255 
STORAGE( INITIAL 20971520 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
NOCACHE 
MONITORING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_OFFER_COURSESETS_PIDX
    ON SAKAI_EXTERNAL.BANNER_OFFERING_COURSESETS(COURSEOFFERING_EID, COURSESET_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 50331648 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_OFFER_COURSESETS_IDX2
    ON SAKAI_EXTERNAL.BANNER_OFFERING_COURSESETS(COURSESET_EID, COURSEOFFERING_EID)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE( INITIAL 52428800 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING 
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_OFFERING_COURSESETS TO SAKAI_EXTERNAL_SELECT
GO