Create Section Error - TIP. If there are currently no zeros in the column, promote AHM

I am trying to split an existing table into a year (no existing partitions)

alter table test_table PARTITION BY EXTRACT (year FROM date_c);

But there seems to be some mistake

ROLLBACK 2628: The column "date_c" in the PARTITION BY clause is not valid because it contains NULL ** TIP. If the column does not currently contain zeros, advance AHM and clear the zeros of the delete vectors before changing the partition **

There is no null value in the column, so a hint. I am promoting AHM right now. But how to clear zeros of removal vectors?

+3
source share
2 answers

AHM (Ancient History Marker) PURGE_TABLE() .

MAKE_AHM_NOW() . AHM LGE (Last Good Epoch). ( ) , . .

+3

, AHM () ( , AHM () ).

0