ORA-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: If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments.
1 increase the setting of UNDO_RETENTION 2 use larger rollback segments
在执行大事务时,有时oracle会报出如下的错误:ORA-01555:snapshot too old (rollback segment too small)这说明oracle给此事务随机分配的回滚段太小了,这时可以为它指定一个足够大的回滚段,以确保这个事务的成功执行.例如set transaction use rollback segment roll_abc;delete from table_name where ...commit;回滚段roll_abc被指定给这个delete事务,commit命令则在事务结束之后取消了回滚段的指定。
select segment_name from dba_rollback_segs; 看下RBSA_19的存储参数还有状态。
我可以肯定不存在“RBSA_19”回滚蛋段。 我特别加大RBS11也是为了让事务可以顺利完成 set transaction use rollback segment RBS11;可以结果依旧....
2 use larger rollback segments
看下RBSA_19的存储参数还有状态。
我特别加大RBS11也是为了让事务可以顺利完成
set transaction use rollback segment RBS11;可以结果依旧....
并且在导入的时候,指定commit参数