My Oracle Support Banner

ORA-55624 When Trying To Re-enable Flashback Data Archive on a Table After Performing DLL on the Table (Doc ID 1100467.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Using Flashback Data Archive

Disabled Flashback Archiving on a table then performed a DDL on the table, ie adding a constraint or a new table.

When trying to to re-enable Flashback Archive, the following error is reported:

"ORA-55624: The table "<username>"."<table_name>" cannot be enabled for Flashback Archive at this point" .

Attempt to re-enable the Flashback Archive after 24-48 hours succeed


Using client release prior to 11.2, such as sqlplus release or


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.