Oracle Error ORA-38883: Cannot shrink data file string on primary database due to guaranteed restore points.

Oracle Error Message

ORA-38883: Cannot shrink data file string on primary database due to guaranteed restore points.

Reason for the Error

An attempt was made to shrink a data file on a primary database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo the shrinking of a data file.

Solution

Drop all guaranteed restore points first and retry, or delay the data file resize until all guaranteed restore points are removed.