In this post, you’ll learn more about the Oracle ErrorORA-38880: Cannot advance compatibility from string to string due to guaranteed restore points with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-38880: Cannot advance compatibility from string to string due to guaranteed restore points
Reason for the Error ORA-38880: Cannot advance compatibility from string to string due to guaranteed restore points
Flashback database cannot undo the advance of database compatibility. Therefore, one cannot advance the compatibility of the database while there are guaranteed restore points in the database.
How to fix the Error ORA-38880: Cannot advance compatibility from string to string due to guaranteed restore points ?
You can fix this error in Oracle by following the below steps
Drop all guaranteed restore points first and retry, or delay the advance of database compatibility to a later time.