ora-00902:无效数据类型createtableZX_K_HY_RSVR_INFO(RSCDchar(6)notnull,RSNMvarchar2(40)notnull,DMSTATPLvarchar2(40),ALLSTnumber(9,2),RGFLRSCPnumber(9,2),ACTCPnumber(9,2),N... ora-00902:无效数据类型
create table ZX_K_HY_RSVR_INFO
(
RSCD char(6) not null,
RSNM varchar2(40) not null,
DMSTATPL varchar2(40) ,
ALLST number(9,2) ,
RGFLRSCP number(9,2) ,
ACTCP number(9,2) ,
NRMZ number(8,3) ,
CKFLZ number(8,3) ,
DSFLZ number(8,3) ,
SRGFLLV number(8,3) ,
ARGFLLV number(8,3) ,
DDZ number(8,3) ,
RSAREA number(10,2) ,
RGLOCP number(9,3) ,
DDCP number(9,3) ,
DRQ number(9,3) ,
CDRQ number(9,3) ,
ORGID char(9) ,
RVID char(8) ,
MDDT DATA ,
MDPS varchar2(40) ,
NT varchar2(500) ,
REMARK char(11) ,
primary key (RSCD)
)
解决了，因为 MDDT DATA ,
应该是MDDT DATE ,