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