当要把某个表闪回到很长一段时间之前时,报如下错误(黑色字体部分为变量,每次都有可能不同)
ORA-0155: 快照过旧:回退段号10(名称为 “_SYSSMU10$”)过小
解决办法:把回滚段的时间增加
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as wmis_rfid
SQL>
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_tablespace string UNDOTBS1
SQL>
System altered
SQL> show parameter undo;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_tablespace string UNDOTBS1
SQL>