ora-01555

1.

   在执行批量数据库查询和更新的时候报

 

java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$" too small

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
    at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java)
    at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java)
    at com.xlh.gjhohj.DBPasswordFzdc.main(DBPasswordFzdc.java:31)

 

 

增加回滚段

 

alter tablespace add datafile 'undotbs2.dbf' size 50M