We have an application that sends CSV flat files for sqlldr loading to an Oracle schema that warehouses the data for reporting. Part of this process is a change reporting function to show what has changed on each Oracle table after the sqlldr runs. A Java program was written to scan certain tables to print change reports for infrequently changing tables. Is there an Oracle function that can we might use that can rapidly scan and cull table changes for such reportiug? I am totally unfamiliar with any of the Oracle Reports and Forms features if there is anything in that suite that can be used. Also I am not sure of what DBA functions could be used. The type of information reported on might be customer account or employee work assignment changes.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reporting on static table data changes
- Thread starter raygg
- Start date
I am not aware of any built-in function so far. But...
You could make use of database triggers to catch any updates made on a table. This will require some programming, analysis on which table to monitor, and additional table to handle the changes. Some sort of an audit table.
OR
You could turn on auditing feature of Oracle, but be extra careful with this one for it could blow up your System tablespace. You better coordinate with your DBA on this one first.
Robbie
- Status
Similar threads
- Locked
- Question