ORACLE分表，增加分表报错alter无效

[狂奔的小笼包]

alter fa_val_chag_test add partition data_2010 values less than (to_date('2011-01-01','yyyy-mm-dd')) tablespace jszc;
执行这个就提示alter无效。


前面建表的时候的分表语句：
......
partition by range (chag_date)
(
partition data_2007 values less than (to_date('2008-01-01','yyyy-mm-dd')) tablespace jszc,
partition data_2008 values less than (to_date('2009-01-01','yyyy-mm-dd')) tablespace jszc,
partition data_2009 values less than (to_date('2010-01-01','yyyy-mm-dd')) tablespace jszc）

[js14982]

alter table fa_val_chag_test ... 是不是掉了个 table 关键字

[ghx287524027]

alter TABLE fa_val_chag_test add partition data_2010 values less than (to_date('2011-01-01','yyyy-mm-dd')) tablespace jszc;