Dear all,
Per note 2289491, I want to imple two-level partitioning (range-range) for table acdoca, as our acdoca has huge volume data.
I want to use FISCYEARPER for the first level and RBUKRS for the second level.
My alter command is:
alter table SAPHANADB.ACDOCA partition by range (FISCYEARPER) ( partition '1990001' <= values < '2021005' )
SUBPARTITION by range (RBUKRS) ( partition '0000' <= values < '1100' )
And I got error saying sql syntax error near SUBPARTITION.
Anyone can help, thanks.
Jia