如果在已有索引的表中添加字段?ORACLE8
我建表的脚本如下:
create table CUSTOMERMASTER
(
CONSIGNORCODE CHAR(6) not null,
CUSTOMERCODE CHAR(5) not null,
CUSTOMERNAME VARCHAR2(80) not null,
CUSTOMERRANK NUMBER(2) not null,
ITEMCATEGORY CHAR(2) not null,
CUSTOMERCLASS CHAR(2) not null,
CUSTOMERSUBCLASS CHAR(3) not null,
CUSTOMERADDRESS1 VARCHAR2(60) null ,
CUSTOMERADDRESS2 VARCHAR2(60) null ,
CUSTOMERZIPCODE VARCHAR2(6) null ,
CUSTOMERTEL VARCHAR2(12) null ,
CUSTOMERFAX VARCHAR2(12) null ,
CUSTOMERSHORTNAME VARCHAR2(20) not null,
RENEWDATE DATE default SYSDATE null ,
WHOIS CHAR(8) null ,
COMPID CHAR(3) null ,
AREACODE CHAR(4) not null,
constraint PK_CUST primary key (CONSIGNORCODE, CUSTOMERCODE, ITEMCATEGORY, CUSTOMERCLASS, CUSTOMERSUBCLASS)
表中已存在大量数据。后来需要增添一个字段:
做如下修改:
SQLPLUS> ALTER TABLE customermaster ADD AREACODE CHAR(4);
提示错误
ORA-25182: 对于按索引编排的表,此特征当前不可用
如果不重新建表,插入数据,有没有解决的办法?