How to fix the Oracle error ORA-55637: Flashback Data Archive enabled table “string”.”string” is not in the correct compliance mode for this operation?

In this post, you’ll learn more about the Oracle ErrorORA-55637: Flashback Data Archive enabled table “string”.”string” is not in the correct compliance mode for this operation with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-55637: Flashback Data Archive enabled table “string”.”string” is not in the correct compliance mode for this operation

Reason for the Error ORA-55637: Flashback Data Archive enabled table “string”.”string” is not in the correct compliance mode for this operation

An attempt was made to perform disassociation operation on a Flashback Data Archive enabled table that is in compliance mode. Or, DDL are not supported on tables in noncompliance mode.

How to fix the Error ORA-55637: Flashback Data Archive enabled table “string”.”string” is not in the correct compliance mode for this operation ?

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

Disable compliance mode before retrying the disassociation operation.