马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册
×
我不知道要怎么对数据进行些修改然后再在sybase执行导入,比如我给个例子,请大家帮我看看要怎么修改后才能在sybase里执行
prompt PL/SQL Developer import file
prompt Created on 2009年5月21日 星期四 by Administrator
set feedback off
set define off
prompt Disabling triggers for CFG_ALARMTYPE...
alter table CFG_ALARMTYPE disable all triggers;
prompt Deleting CFG_ALARMTYPE...
delete from CFG_ALARMTYPE;
prompt Loading CFG_ALARMTYPE...
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (50, '硬件接口板卡类告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (53, '硬件射频类告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (54, '硬件其它类', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (55, '系统内部通信告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (56, '性能告警无线-系统软件告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (57, '硬件内部交换类告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (58, '硬件时钟类告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (3, '环境告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (1, '通信告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (4, '设备告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (2, '服务质量告警', '3', 1);
insert into CFG_ALARMTYPE (ID, ALARMTYPE, NE_LEVEL, ISEFFECT)
values (13, '其他类告警', '3', 1);
prompt 12 records loaded
prompt Enabling triggers for CFG_ALARMTYPE...
alter table CFG_ALARMTYPE enable all triggers;
set feedback on
set define on
prompt Done. |