create table table1(a_id            number,      
                    a_id_last_digit number,
                    a_date          date,
                    a_country       varchar2(10),
                    a_sum           number)
  partition by range (a_date) interval (numtoyminterval(1, 'month'))
  subpartition by list (a_country)
  subpartition template (
    subpartition rus values ('rus'), 
    subpartition usa values ('usa'))
  (partition p0  values less than (to_date('2001-01-01', 'yyyy-mm-dd', 'nls_calendar=gregorian')));

create table table2(a_id            number,
                    a_id_last_digit number,
                    a_date          date,
                    a_country       varchar2(10),
                    a_sum           number)
  partition by list(a_id_last_digit)
(partition p0 values (0)
,partition p1 values (1)
,partition p2 values (2)
,partition p3 values (3)
,partition p4 values (4)
,partition p5 values (5)
,partition p6 values (6)
,partition p7 values (7)
,partition p8 values (8)
,partition p9 values (9));

insert into table2 (a_id,
                    a_id_last_digit,
                    a_date,
                    a_country,
                    a_sum)
SELECT a_id,
       mod(a_id, 10),
       add_months(trunc(sysdate, 'mm'), -round(dbms_random.value(1, 60))),
       'rus',
       round(dbms_random.value(1, 10000))
  from (select round(dbms_random.value(10000000000, 200000000000)) a_id
          from dual
       connect by level < 25000000);