Re: automated history with Oracle?

You have a few options available to you...

1. You can use LogMiner to go through the archived redo logs to see which transactions occurred on your tables of interest. I would recommend this tool if you need to do this once or twice, but not on a regular basis. However, if you have not set up any of the options below, this may be your only way to retrieve the information until one of the other options is implemented.
2. Use auditing. See the following doc for more details:

http://download-east.oracle.com/docs/cd/B19306_01/network.102/b14266/toc.htm

3) If auditing does not meet your needs, then create a trigger to capture information you need when DML is performed. Store the information in a table to be queried later. In this sense, you are implementing your own auditing, but you can do more here.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown