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 ...
We're creating a new version of a 20 years old database, in which we used to keep version history by creating new rows in each table (SCD Type 2). SCD Type 2 is not that hard when you need to keep ...
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 ...