Hello Tom,
With the following command :
SQL> select TABLE_NAME, FLASHBACK_ARCHIVE_NAME, ARCHIVE_TABLE_NAME, STATUS
from DBA_FLASHBACK_ARCHIVE_TABLES;
TABLE_NAME FLASHBACK_ARCHIVE_NAME ARCHIVE_TABLE_NAME STATUS
-------------- --------------------------- -------------------------- ----------
TB_PRODUCTS FBA1 SYS_FBA_HIST_91091 ENABLED\
I can determine that a TABLE is enabled for FLASHBACK DATA ARCHIVE.
How do I find the day and time when this TABLE was enabled for FLASHBACK DATA ARCHIVE using the following command :
ALTER TABLE TB_PRODUCTS FLASHBACK ARCHIVE FBA;
sometime before.
Best Regards
That view is based on 2 internal tables SYS_FBA_FA and SYS_FBA_TRACKEDTABLES, neither of which contain a date/timestamp column.
However, you can get an approximation by looking at the creation date for the supporting flashback tables (the HIST and TCRV tables). Just look at the CREATED column in USER_OBJECTS.
Note - this is an *approximation* because we create those tables on demand, thus if you enabled FDA in January and did no DML on those tables until March, then it is in March that we would create the tables.