This content has been marked as final. Show 4 replies
user13809017 wrote:I give up.
While doing Re-org ,we getting Ora-01555.We using 11g.
Alter table CMAR.HISTT move;
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_4050276716$" too small.
Can we restart again?
I would expect the same error as log as DML occurs against CMAR.HISTT table
Can we again execute?
Yes, you can.
It is entirely reasonable to expect, however, that it will fail again with the same error.
ORA 01555 "snapshot too old: rollback segment number %s with name \"%s\" too small" [ID 1555.1]