How to disable flashback query logging for a specific table (Oracle)?
3
votes
3
answers
2612
views
We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it would be beneficial to have access to more historical data.
We would like to either restrict logging on that table. Or disable it completely. I imagine that we may be able to do this by tablespace, I just have not found much on how to make these changes.
Asked by Arturo Hernandez
(276 rep)
Jul 25, 2013, 10:01 PM
Last activity: Nov 1, 2016, 06:25 PM
Last activity: Nov 1, 2016, 06:25 PM