CREATE TABLE SAKAI_EXTERNAL.BANNER_INSTRUCTORS (
ENROLLMENTSET_EID VARCHAR2(74) NULL,
SECTION_EID VARCHAR2(91) NULL,
PIDM NUMBER(8,0) NOT NULL,
ROLE CHAR(10) NULL,
STATUS CHAR(6) NULL,
TERM_CODE VARCHAR2(18) NOT NULL,
CRN VARCHAR2(15) NOT NULL,
CATEGORY VARCHAR2(6) NOT NULL,
SIRASGN_ROW ROWID NOT NULL,
SSBSECT_ROW ROWID NOT NULL
)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 83886080 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
NOCACHE
MONITORING
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_INSTRUCTORS_ES_IDX
ON SAKAI_EXTERNAL.BANNER_INSTRUCTORS(ENROLLMENTSET_EID, PIDM)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 34603008 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
CREATE INDEX SAKAI_EXTERNAL.BANNER_INSTRUCTORS_S_IDX
ON SAKAI_EXTERNAL.BANNER_INSTRUCTORS(SECTION_EID, PIDM)
TABLESPACE DATA_TS PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE( INITIAL 34603008 MINEXTENTS 1 MAXEXTENTS 2147483645 )
PARALLEL( DEGREE 1 )
LOGGING
GO
GRANT SELECT ON SAKAI_EXTERNAL.BANNER_INSTRUCTORS TO SAKAI_EXTERNAL_SELECT
GO