案例:
以下建表脚本在pl/sql中可以正常执行,但是在oracle中执行时报了00955的错误:
ORA-00955: name is already used by an existing object
Table created.
create table PO_APD_ADCOLUMN
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Table created.
create table PO_APD_ADCOLUMN
(
ADCOLUMNID VARCHAR2(100) not null,
ADCOLUMNNAME VARCHAR2(100) not null,
TERMINALTYPE VARCHAR2(100) not null,
DISPLAYMODE NUMBER(2) not null,
WIDTH VARCHAR2(10) not null,
HEIGHT VARCHAR2(10) not null,
--modify by xxxxxxxx 2009-08-10
DESCRIPTION VARCHAR2(2000),
RELEASESTATUS NUMBER(2) default 0,
INTERVALTIME INTEGER,
RESERVE2 VARCHAR2(100),
RESERVE3 VARCHAR2(100)
)
/