Oracle - Need to capture change in data rows in a table without using triggers

Kushal Rastogi 0
Viewed 22

Need to capture change for each column for each row in a table without using triggers

Before: Id Name Address
1 A LUCKNOW
2 B PUNE

After:

Id Name Address
1 A DELHI
2 B PUNE

Need to capture the change for id =2 and report the column that was changed. Can this be achieved without using triggers.

oracle
1 Answers

If your Oracle is 11.2.0.4+ take a look at Flashback Data Archive.

CREATE FLASHBACK ARCHIVE test_archive
   TABLESPACE <your_ts>
   QUOTA 1 M
   RETENTION <some_period> DAY;
 
ALTER TABLE <your_table>
   FLASHBACK ARCHIVE;

For reference

Gnqz0
Related