Oracle Error ORA-55604: Incorrect tablespace is specified

Oracle Error Message

ORA-55604: Incorrect tablespace is specified

Reason for the Error

An incorrect tablespace is specified for the Flashback Archive.

Solution

Check the SQL statement and verify the possible causes, 1, the tablespace that was already used by the Flashback Archive. 2, the tablespace was not used by the Flashback Archive. 3, the tablespace block size is less than 8K.