Skip to Content
0
Sep 01, 2023 at 08:40 AM

incorrect syntax near "SUBPARTITION"

73 Views

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