For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi Is it possible to create an interval range partition in a table by year? Something like below. Unfortunately it does not work.
PARTITION BY RANGE ("TR_DATE") INTERVAL (NUMTOYINTERVAL(1,'YEAR'))
Thanks for your help
Regards