1、查看参数

show enable_incremental_checkpoint;

2、如果结果是on，将其修改成off

alter system set enable_incremental_checkpoint to off;

3、重启数据库

4、创建MOT表、插入数据、创建索引

drop FOREIGN table if exists mot_mytest_0819;
create FOREIGN table mot_mytest_0819(x int);
insert into mot_mytest_0819(x) values (99);
create index  idx_mot_mytest_0819 on mot_mytest_0819(x) ;