interval partitioning on a number column
Hi ,
I have got a requirement for interval partitioning of a column which contains date whose data type is number .
I have asked to do a partitioning for 3 months .Can anyone get me a syntax for doing it .Thanks in advance .
I tried the below syntax .But was not able to get partitioning for 3 months .
create table test
( prod_id number,
prod_code varchar2(3),
release_date number
)
partition by range(release_date)
interval(300)
(partition empty values less than (20000301) )
/
Regards,
Nash