interval partition on number data type
Hi,
I got some issues for defining an interval partition table on a numeric column, any help will be very much appreciated.
Say we have a table, which is sort of periodic fact table, we want to use interval partition on the column PERIOD_DATE_KEY. What's stored in this field is a number format for a date, say if the date is Jan-31-2010, the value in the field is 20100131 as a number.
The interval for this table is one month. See the table below.
SALES_INTERVAL_MONTH_T1
(
PERIOD_DATE_KEY NUMBER(10), -- date in a format of to_number(to_char(to_date('20100120','yyyymmdd'),'yyyymmdd'))
I got some issues for defining an interval partition table on a numeric column, any help will be very much appreciated.
Say we have a table, which is sort of periodic fact table, we want to use interval partition on the column PERIOD_DATE_KEY. What's stored in this field is a number format for a date, say if the date is Jan-31-2010, the value in the field is 20100131 as a number.
The interval for this table is one month. See the table below.
SALES_INTERVAL_MONTH_T1
(
PERIOD_DATE_KEY NUMBER(10), -- date in a format of to_number(to_char(to_date('20100120','yyyymmdd'),'yyyymmdd'))
0