表结构已经建好，用exp导出oracle后，怎么导入sybase？
我不知道要怎么对数据进行些修改然后再在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. 试试PB的数据管道看。
页:
[1]