How to fix the Oracle error ORA-55631: Table has columns with data types that are not supported by Flashback Data Archive?

In this post, you’ll learn more about the Oracle ErrorORA-55631: Table has columns with data types that are not supported by Flashback Data Archive with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-55631: Table has columns with data types that are not supported by Flashback Data Archive

Reason for the Error ORA-55631: Table has columns with data types that are not supported by Flashback Data Archive

An attempt was made to add a column of data type that is not supported by Flashback Data Archive. Or, the table on which Flashback Data Archive is being enabled contains column(s) with data types not supported by Flashback Data Archive.

How to fix the Error ORA-55631: Table has columns with data types that are not supported by Flashback Data Archive ?

You can fix this error in Oracle by following the below steps

Do not use FLASHBACK ARCHIVE clause for this object. If adding column, do not use LONG or Nested Table column data type.