表名这样定义好像有冲突,具体原因我也不清楚,你只要把表名改了就行了。 CREATE TABLE REFERDATUMS--修改表名 ( ID NUMBER (10) NOT NULL, PROID VARCHAR2 (20), SUBPROID NUMBER (20), SPECID NUMBER (30), STAFFNO VARCHAR2 (10), RTIME DATE, STATUS VARCHAR2(20) DEFAULT '提交' );
用 select * from dba_objects where owner='DOCMAN' and object_name='REFERDATUM'; 查一下是否有重名
CREATE TABLE REFERDATUMS--修改表名
(
ID NUMBER (10) NOT NULL,
PROID VARCHAR2 (20),
SUBPROID NUMBER (20),
SPECID NUMBER (30),
STAFFNO VARCHAR2 (10),
RTIME DATE,
STATUS VARCHAR2(20) DEFAULT '提交'
);
select * from dba_objects where owner='DOCMAN' and object_name='REFERDATUM';
查一下是否有重名
drop table "DOCMAN.REFERDATUM";