create or replace PROCEDURE PRC_PARTITIONWEEK(p_tablename varchar2,start_date date,end_date date , p_partitionname varchar2) AS 
v_sql varchar2(1000);
v_partname varchar2(100);
v_months number;
v_date date;
wknum number;
vyear number;
v_sdate date:=TO_CHAR(TO_DATE(start_date,'DD-MON-YY'),'DD-MON-YYYY');

BEGIN
	select MONTHS_BETWEEN 
   ((TO_CHAR(TO_DATE(end_date,'DD-MON-YY'),'DD-MON-YYYY')),
    TO_CHAR(TO_DATE(start_date,'DD-MON-YY'),'DD-MON-YYYY') ) into v_months from dual;
	
	for i in 1..v_months LOOP
	
	SELECT to_char(LAST_DAY(v_sdate), 'iw' )+1 ,
         (CASE to_number(to_char(LAST_DAY(v_sdate),'iw'))
         WHEN 52 THEN to_char( LAST_DAY(v_sdate), 'yyyy' ) 
         WHEN 01 THEN to_char( LAST_DAY(v_sdate)+6, 'yyyy' )
         ELSE to_char( v_sdate, 'yyyy' )
         END) vyear
  INTO wknum,vyear from dual;
 
		select TO_CHAR(TO_DATE(v_sdate,'DD-MON-YY'),'DD-MON-YYYY') into v_date from dual;
    
		select  p_partitionname||'_'||to_char(trunc(trunc(TO_DATE(v_date,'DD-MON-YY'), 'MM'), 'MM'),'MMYYYY') --"Month and year of given date"
		into v_partname
		from dual;
    		  
		v_sql:='ALTER TABLE '||p_tablename ||'  ADD PARTITION '||v_partname ||' VALUES LESS THAN ('||vyear||','||wknum||') TABLESPACE PEGADATA ';
  
    dbms_output.put_line('partname '||v_partname  || 'sql  '|| V_SQL); 
  
		EXECUTE IMMEDIATE V_SQL;
	
		v_sdate:=add_months(v_sdate,1);
	
	END LOOP;
	COMMIT;
END PRC_PARTITIONWEEK;

select date '2016-12-31' + level dt,
       to_char(date '2016-12-31' + level,'ww') week_number
  from dual
  connect by level <= 370
/
...
29-DEC-17 52
30-DEC-17 52
31-DEC-17 53 -- one day week
01-JAN-18 01
02-JAN-18 01
03-JAN-18 01
04-JAN-18 01
05-JAN-18 01

create table tbl(
                 dt date,
                 year number generated always as (extract(year from dt)),
                 week number generated always as (to_number(to_char(dt,'ww')))
                )
  partition by range(year)
    interval(1)
    subpartition by range(week)
      subpartition template(
                            subpartition w1 values less than(2),
                            ...
                            subpartition w53 values less than(54)
                           )
  (
   partition y2000_and_before values less than(2001)
  )
/

create table tbl(
                 dt date,
                 week number generated always as (53 * to_number(to_char(dt,'syyyy')) + to_number(to_char(dt,'ww')) - 1)
                )
  partition by range(week)
    interval(1)
  (
   partition y2000_and_before values less than(106053)
  )
/

CREATE TABLE MY_PART_TABLE
(
  MY_DATE       DATE                            NOT NULL,
  MY_PART_DATA  VARCHAR2(7 BYTE) INVISIBLE GENERATED ALWAYS AS (TO_CHAR("MY_DATE",'YYYY-WW'))
)
TABLESPACE USERS
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            BUFFER_POOL      DEFAULT
           )
PARTITION BY LIST (MY_PART_DATA) AUTOMATIC
(  
  PARTITION FIRST_PART VALUES ('2000-01')
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   1
    MAXTRANS   255
    STORAGE    (
                MAXEXTENTS       UNLIMITED
                BUFFER_POOL      DEFAULT
               )
);