When one of the SQL programmers in our group tries to load a lot of records (approx. 130K), only 124K are loaded. The error ORA-01555 "snapshot too old (rollback segment too small)" appears.In accordance with Loney's book "ORACLE DBA Handbook", the RBS_2 tablespace was created with a large datafile andlarge rollback segments esclusively for large data loads. However, the problem continues when anymore than 124K records are loaded. Any suggestions????? Received on Thu Dec 28 1995 - 00:00:00 CET
Original text of this message