Skip to Main Content

SQL & PL/SQL

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!

Tracking data changes to a table

GaillimhOct 29 2014 — edited Oct 29 2014

Hi, I have a general question about how you would track or audit changes on a table if the table didn't have any audit triggers turned on.

E.g. if a table had rows inserted, updated or deleted what would the approach be ? I was thinking that you could create a temp table and compare both tables using minus or maybe across the primary keys.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2014
Added on Oct 29 2014
2 comments
1,299 views