interval partition/range partition question
Hello,
I am new to partitoins and have question need help.
Basically my goal is to setup period column with either intever partition or range partition scheme which most suitable to my data below.
The period column have year(2014,2015,2016) and accounting period(001,002,003 combination (2014001)
Period
2014001
2014002
2014003
2014004
....
...
2015001
...
What will be syntax for partitoin table create if I would like to setup interval partition ? If interval not possible then what will be syntax for range ?
I tried below but not working -
create table test(period number(15) not null)
partiton by list(period) interval(numtoyminterval(001,'MONTH')
(partiton part_1 values less than 2014002
....
It's giving me error - invalid option ...