/* Create main table to be partitioned */
CREATE TABLE STUDENT_WKLY
 (STUDENT_ID NUMBER(8,0) NOT NULL
 ,SALUTATION VARCHAR2(5)
 ,FIRST_NAME VARCHAR2(25)
 ,LAST_NAME VARCHAR2(25)  NOT NULL
 ,STREET_ADDRESS VARCHAR2(50)
 ,ZIP VARCHAR2(5) NOT NULL
 ,PHONE VARCHAR2(15)
 ,EMPLOYER VARCHAR2(50)
 ,REGISTRATION_DATE DATE  NOT NULL
 ,CREATED_BY VARCHAR2(30) NOT NULL
 ,CREATED_DATE DATE  NOT NULL
 ,MODIFIED_BY VARCHAR2(30)  NOT NULL
 ,MODIFIED_DATE DATE  NOT NULL
 );


/***
Primay key on partition main table 
***/

ALTER TABLE STUDENT_WKLY ADD CONSTRAINT STDTW_PK PRIMARY KEY (STUDENT_ID);


/***
Index on partition main table 
***/

CREATE INDEX STDTW_ZIP_IDX_I ON STUDENT_WKLY (ZIP);

Execute the procedure:
EXEC MANAGE_PARTITIONS.setup_partitions ('PARTSRVC', 'STUDENT_WKLY', 'STDTW', 'REGISTRATION_DATE', 'STUDENT_ID', 'STUDENT_WKLY_VW', 'W', '2020-12-01', 4, 8, 'Y', 'N', 'Y');


SELECT * FROM STUDENT_WKLY_VW;


INSERT INTO STUDENT_WKLY_VW VALUES (20201205,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE-50,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 
INSERT INTO STUDENT_WKLY_VW VALUES (20201215,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE-40,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 

INSERT INTO STUDENT_WKLY_VW VALUES (20210110,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE-30,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 
INSERT INTO STUDENT_WKLY_VW VALUES (20210112,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE-20,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 

INSERT INTO STUDENT_WKLY_VW VALUES (20210221,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE-10,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 
INSERT INTO STUDENT_WKLY_VW VALUES (20210216,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 

INSERT INTO STUDENT_WKLY_VW VALUES (20210222,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE+20,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 
INSERT INTO STUDENT_WKLY_VW VALUES (20210228,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE+40,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 

INSERT INTO STUDENT_WKLY_VW VALUES (20200308,'Mr.','TEST 111','Last name','101-09 120th St.','11419','718-555-5555','ABC Education Co.'
,SYSDATE+50,'ADMIN',SYSDATE,'ADMIN',SYSDATE); 

SELECT * FROM STUDENT_WKLY_VW;

update STUDENT_WKLY_VW set first_name = first_name || ' - UPDATED' where student_id = 20201205;

SELECT * FROM STUDENT_WKLY_VW;

delete FROM STUDENT_WKLY_VW where student_id = 20210221;

SELECT * FROM STUDENT_WKLY_VW;