FLASHBACK DATA ARCHIVE is enabled condition
Partha ROY, June 03, 2021 - 11:40 am UTC
Hello Tom,
Thank you for the detailed link and video. It was helpful.
In my database, FLASHBACK DATA ARCHIVE feature is already enabled.
Under this setup where FLASHBACK DATA ARCHIVE is already enabled, is there any way to get the SCN for MINVALUE and MAXVALUE by some query?
Or, I will have to understand the link you sent earlier to create some PL/SQL code to query internal tables [undocumented features] and map MINVALUE/MAXVALUE to SCN?
I thought MINVALUE and MAXVALUE are documented Keywords and hence there must be some documented way to map MINVALUE/MAXVALUE to SCN when FLASHBACK DATA ARCHIVE feature is enabled for an User TABLE.
Best Regards
June 08, 2021 - 2:34 am UTC
Checking when the TCRV/HGIST tables were created would be a reasonable approximation to when flashback data archive was enabled. I say *reasonable* because they get created on demand as they are needed, so it might be slightly *after* the time you enabled FDA.