Oracle DBA, How To, Error, Cause and Action

ORA-01558: out of transaction ID's in rollback segment string

ORA-01558: out of transaction ID's in rollback segment string




Cause: All the available transaction id's have been used




Action: Shutdown the instance and restart using other rollback segment(s), then drop the rollback segment that has no more transaction id's.