Oracle Error ORA-38881: Cannot drop tablespace string on primary database due to guaranteed restore points.

Oracle Error Message

ORA-38881: Cannot drop tablespace string on primary database due to guaranteed restore points.

Reason for the Error

An attempt was made to drop a tablespace on a primary database while there are guaranteed restore points. You cannot do this because Flashback database cannot undo dropping of a tablespace.

Solution

Drop all guaranteed restore points first and retry, or delay dropping the tablespace until all guaranteed restore points are removed.