Oracle Error ORA-38766: cannot flashback data file string; file resized smaller

Oracle Error Message

ORA-38766: cannot flashback data file string; file resized smaller

Reason for the Error

An attempt to do FLASHBACK DATABASE found that the file was shrunk during the time to flash back.

Solution

The file cannot be flashed back. The file must be taken offline or the tablespace dropped before continuing with the FLASHBACK DATABASE command.