Hi,
ORA-01555 ERROR MESSAGE “SNAPSHOT TOO OLD”
Our production db size is 8 TB and we having to BCV copy of production db (read only mode) on different servers. One of the bcv copy we received above said error. undo setting like
undo_management=auto; undo_retention=5400; undo tablespace free space:=80GB;
All the indexes for error tables was in "valid" state. But as per the oracle recomandation we rebuild the indexes. mainly primary key having the issue.
Till today above error only occurred on BCV copy( but received only at one copy. Another copy doesn't occurred error ). But today we got above error on production db.(error received at application side. not recorded in alert file).
My question is why this error occured , when all indexes in valid stage , enough free space for undo?
And how to find which indexes are causing the problem in future?
Thanks
Pravin