- 源码:
smoketest:/tmp # cat 321.log
create table “omuuser”.“t_omu_spec_nic”
(
“ID” NUMBER(19,0) not null,
“NETWORKNAME” VARCHAR2(50 CHAR),
“SPECNAME” VARCHAR2(255 CHAR) not null,
primary key (“ID”)
);
alter table “omuuser”.“cie_support_idgenerator” drop primary key;
====================================================
测试命令:
smoketest:/tmp # sed -i ‘/table/s/"//g’ 321.log
======================================
查看效果:
smoketest:/tmp # cat 321.log
create table omuuser.t_omu_spec_nic
(
“ID” NUMBER(19,0) not null,
“NETWORKNAME” VARCHAR2(50 CHAR),
“SPECNAME” VARCHAR2(255 CHAR) not null,
**
primary key (“ID”)
**
);
alter table omuuser.cie_support_idgenerator drop primary key;
=======================================================
找到以 table 为关键字这行,并将前面的指定字符 " 删除
[root@vlin133-11 tmp]# cat 333.log
smoketest:/tmp # cat 321.log
create table omuuser.t_omu_spec_nic
(
“ID” NUMBER(19,0) not null,
“NETWORKNAME” VARCHAR2(50 CHAR),
“SPECNAME” VARCHAR2(255 CHAR) not null,
primary aaaa (“ID”)
);
alter table omuuser.cie_support_idgenerator drop primary aaaa;
sed -i ‘/primary/s/aaaa/key/’ 333.log
[root@vlin133-11 tmp]# cat 333.log
smoketest:/tmp # cat 321.log
create table omuuser.t_omu_spec_nic
(
“ID” NUMBER(19,0) not null,
“NETWORKNAME” VARCHAR2(50 CHAR),
“SPECNAME” VARCHAR2(255 CHAR) not null,
**
primary key (“ID”)
**
);
alter table omuuser.cie_support_idgenerator drop primary key;