Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Shanmuga Priya.
Asked: October 17, 2016 - 8:00 am UTC
Last updated: May 11, 2020 - 5:18 am UTC
Version: 11g
Viewed 50K+ times! This question is
create flashback archive app_archive tablespace users retention 7 year; alter table customer_addresses flashback archive app_archive;
/* What did the data look like yesterday? */ select * from customer_addresses as of timestamp sysdate - 1; /* What between yesterday and now? */ select * from customer_addresses versions between timestamp sysdate - 1 and sysdate;
Derzkii, September 19, 2017 - 7:18 am UTC
SS, May 11, 2020 - 12:46 am UTC
Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.