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";