oracle 新建表标识符无效,新建表的时候报错，ORA-00904: : 标识符无效;

CREATE TABLE "CHONGQI".P_TestPara(fID VARCHAR2(100),version INTEGER,Case_Id VARCHAR2(100),Position VARCHAR2(100),OnLine INTEGER,Fill_Count INTEGER,LeakGas_Evaluate VARCHAR2(100),Work_Type VARCHAR2(100),Work_Date DATE,Time_Begin DATE,Time_End DATE,T_Interval NUMBER(22,2),Temperature NUMBER(22,1),Humidity NUMBER(22,1),Gas_Humid NUMBER(22,1),Air_Pressure NUMBER(22,2),Input_Press NUMBER(22,2),Bef_Pressure NUMBER(22,2),Aft_Pressure NUMBER(22,2), PRIMARY KEY(fID))

COMMENT ON TABLE "CHONGQI".P_TestPara IS '充气数据'

COMMENT ON COLUMN "CHONGQI".P_TestPara.version IS '版本'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Case_Id IS '箱号'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Position IS '位置'

COMMENT ON COLUMN "CHONGQI".P_TestPara.OnLine IS '是否在线'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Fill_Count IS '充气次数'

COMMENT ON COLUMN "CHONGQI".P_TestPara.LeakGas_Evaluate IS '漏气评估'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Work_Type IS '工作类型'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Work_Date IS '工作日期'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Time_Begin IS '充气开始时间'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Time_End IS '充气结束时间'

COMMENT ON COLUMN "CHONGQI".P_TestPara.T_Interval IS '充气时间间隔'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Temperature IS '温度'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Humidity IS '湿度'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Gas_Humid IS '气体湿度'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Air_Pressure IS '空气压力'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Input_Press IS '输入气体压力'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Bef_Pressure IS '工作前箱内压力'

COMMENT ON COLUMN "CHONGQI".P_TestPara.Aft_Pressure IS '工作后箱内压力'

这个是建表语句，我用dos打开之后用语句建表，就出现图片上面的问题，可是语句我看了，也没错误啊。这是怎么回事啊。

5.jpg

(235.76 KB, 下载次数: 1)

2015-9-21 11:20 上传

建表语句出错