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 ...
i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
I have an databases where changes to data were tracked by adding auditing timestamp columns to the end of each row. I want to migrate to Oracle's Total recall or Flashback archive so I need to trick ...