a pochemy, sobstvenno, tak
select * from table1,table2 partition(month1) union select * from table1,table2 partition(month2) ??

select * from table1,table2 where date_column in (year1, year2, etc..)
ne rabotaet??

I skol'ko rows u tebya budet v new partition?

Ne ponyal, pri chem tut
'А где тут ключевое слово partition.'..
A index tvoigo polya ne znaet, gde kakaya partition?

CREATE TABLE "M5_SUMMARY" ("START_D_T" DATE NOT NULL,
"M_CYCLE" VARCHAR2(2 byte) NOT NULL, "BC_DATE" DATE NOT
NULL, "CATEGORY" VARCHAR2(30 byte) NOT NULL, "CUSTOMER_GROUP"
VARCHAR2(40 byte) NOT NULL, "RATEPLAN" VARCHAR2(30 byte) NOT
NULL, "TMCODE" NUMBER(15), "SERVICE_DESC" VARCHAR2(5 byte)
NOT NULL, "ZN_SHDES" VARCHAR2(5 byte) NOT NULL, "ZP_DIGITS"
VARCHAR2(18 byte) NOT NULL, "REMARK_CODE" VARCHAR2(10 byte)
NOT NULL, "CHARGE_IND" NUMBER NOT NULL, "TRANS_NUM" NUMBER,
"DURATION_CALL_LENGTH" NUMBER, "DURATION_RATED_LENGTH" NUMBER,
"CHARGE_DURATION" NUMBER, "AIR_CALL" NUMBER, "AIR_CHARGE"
NUMBER, "BEFORE_CREDIT" NUMBER, "COLLECT_AMOUNT" NUMBER,
"ENT_DATE" DATE, "CREDIT_IND" VARCHAR2(10 byte))
PCTFREE 15 PCTUSED 85 INITRANS 50 MAXTRANS 255
STORAGE ( FREELISTS 1 FREELIST GROUPS 1)
NOLOGGING
PARTITION BY RANGE ("START_D_T")
SUBPARTITION BY LIST ("M_CYCLE")
(
--
PARTITION "P2001"
VALUES LESS THAN (TO_DATE(' 2001-01-01 00:00:00',
'SYYYY-MM-DD HH24:MI:SS',
'NLS_CALENDAR=GREGORIAN'))
PCTFREE 15 PCTUSED 85
INITRANS 50 MAXTRANS 255 STORAGE ( INITIAL 256M NEXT 280M
MINEXTENTS 50 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
( SUBPARTITION BC_01_P200106 VALUES ('01'),
SUBPARTITION BC_02_P200106 VALUES ('02'), etc
..
enable row movement;

V select dobavitsya
where M_CYCLE in ('01','02','03'...)::

select * from M5_SUMMARY where
TRUNC(START_D_T,'YYYY') = trunc(md,'YYYY')
and
M_CYCLE in ('01','02'

A chto takoe ",table2 "?