I have a table with the format
CREATE TABLE TABLE_NAME
(
YR_MO NUMBER,
COL2 NUMBER,
COL3 VARCHAR2(100)
PARTITION BY RANGE (YR_MO)
INTERVAL (1)
( PARTITION P0 VALUES LESS THAN (200310) )
)
The data in the YR_MO columns is stored in YYYYMM format.
It seems to be working great when the insert for 200310,200311
but for 200312 the high Value is 200313 , which is not a valid Year and Month , where as it should be 200401
becuase the next YYYYMM for 200312 will be 200401 .
column datatype cannot be modified to Date
How can I set the interval partition so that my high value always gets increased by 1 month .
Thanks in advance.