Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to find all DML against table for previous day

spur230Mar 2 2016 — edited Mar 4 2016

Dear all - I have a requirement to find list of modified records ( insert, update, delete ) for few tables for previous business day. I am using Oracle 12.1.0.2 Enterprise edition.

I am not favoring

- GoldenGate :for extra licensing cost

- Streams : deprecated in 12c

- Triggers : Performance impact

I am investing if flashback queries like

SELECT * FROM tablename VERSIONS BETWEEN TIMESTAMP <start> AND <end>

Do I need to setup flashback data archive to consistently get data from previous day ? My undo retention in set at 2700

Is there any other way to achieve it? I do have materialized view log setup on these tables but not sure if I can reliably find out what change with the mv logs.

Thanks for any input.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2016

Added on Mar 2 2016

#12c, #general-database-discussions

22 comments

3,615 views