在执行大事务时,有时oracle会报出如下的错误: ORA-01555:snapshot too old (rollback segment too small) 这说明oracle给此事务随机分配的回滚段太小了,这时可以为它指定一个足够大的回滚段,以确保这个事务的成功执行.例如 set transaction use rollback segment roll_abc;
.....
.....
调试欢乐多
RA-01555 snapshot too old: rollback segment number string with name "string" too smallCause: Rollback records needed by a reader for consistent read are overwritten by other writers.Action: Use larger rollback segments.
回滚段的大小和数目是肯定要改动的了 :)到ITPub.net去搜索一下,一堆一堆的