Is there a way to check if data ever exists in a table before in Oracle?
Using flashback option,
we can check for data like as of timestamp sysdate - x
(where x is time we'd like to see data in past)
But I'd like to know is there any function or utility which Oracle provides so we can know if one particular data ever existed in a table in last 1 week or something.
Sometimes the Flash Recovery Area (FRA) is full and the Oracle DBA wants to know what is it use, size and the list of occupants (archives, RMAN backups pieces or image copies, flashback logs).
Compatibility: Oracle 12c, 11g, 10g
The following statement changes the flashback time from the default of one day to two days:
SQL> alter system set db_flashback_retention_target = 2880;