insert into deal_st(ins,brch_ins) select a.ins,b.ins from (select ins from ins_inf where cata!='02') as a,(select ins from ins_inf where cata='02') as b
提醒数据库事务日志已满。
不想改数据库日志设置。
方法:
1 采用export导出数据。
export to d:\xxx.del of del select a.ins,b.ins from (select ins from ins_inf where cata!='02') as a,(select ins from ins_inf where cata='02') as b
2 采用import导入数据,关键是一定要commitcount 10000来限定一次提交的交易数量。
import from d:\dxxx.del of del commitcount 10000 insert into deal_st(ins,brch_ins)
该贴由system转至本版2014-9-16 15:01:04