By
Published: 14 May 2008
How can you get the history of data modified from an Oracle database?
There are a few options at your disposal. After the fact, you can mine your archived redo logs using Oracle's Log Miner utility. This presumes you have the archived redo logs available. For more information on how to use Log Miner, refer to the following documentation:
Using LogMiner to Analyze Redo Log Files
Before the fact, you can set up auditing to record changes. With auditing, you can record actions in a database table as they happen and then query the table any time in the future. For more information on auditing, please refer to the following documentation:
Database Auditing: Security Considerations
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading