Skip to Main Content

SQL & PL/SQL

Announcement

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!

Partition by Year

user626688Dec 12 2018 — edited Dec 12 2018

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

Comments
Post Details
Added on Dec 12 2018
8 comments
6,346 views