05
12/17
missing PARTITION or SUBPARTITION keyword
修改Oracle表时报这个错, missing PARTITION or SUBPARTITION keyword 是因为语法写错,差一个字段(红色): alter TABLE "UserCars" add "EngineNo2" nvarchar2(50); update "UserCars" set "EngineNo2" = "EngineNo"; alter TABLE "UserCars" drop column "EngineNo"; alter TABLE "UserCars" rename column "EngineNo2" to "EngineNo";