您不能将分区添加到尚未分区的现有表中，但是只能从分区表中添加或删除范围。
唯一的方法是创建一个新表和INSERT / SELECt，如下所示：
CREATE SET TABLE ONLINE_BANKING.TRANSACTIONS_PPI ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( transaction_id INTEGER NOT NULL, date_of_transaction DATE FORMAT 'YYYYMMDD' NOT NULL, amount_of_transaction DECIMAL(38,2) NOT NULL, transaction_type_pre BYTEINT NOT NULL DEFAULT 25 , ...)PRIMARY INDEX ( transaction_id )PARTITION BY RANGE_N (date_of_transaction BETWEEN DATE '1998-01-01' AND DATE '2015-12-31' EACH INTERVAL '1' MONTH);INSERT INTO ONLINE_BANKING.TRANSACTIONS_PPISELECT * FROM ONLINE_BANKING.TRANSACTIONS;-- when everything is okDROP TABLE ONLINE_BANKING.TRANSACTIONS;RENAME TABLE ONLINE_BANKING.TRANSACTIONS_PPI AS ONLINE_BANKING.TRANSACTIONS;
