history of a specific table in oracle

Question

Can we find the history of values, updates, deletes or inserts of a specific table?

I don't have the access to create a stored procedure. Can you please provide me a query in the answer or some other way to find the history?

Answer 1

Two possibilities come to mind.

1.) If you have auditing enabled, you are all set. But, I'm guessing if that was the case, you wouldn't be asking the question. If you think this request will come up again, you should investigate setting up auditing for future requests.

2.) If auditing isn't set up, there's LogMiner, which allows you to examine the contents of the archived and online redo logs. This is probably your only solution, if you need the details of inserts, updates, deletes to a specific table.

Hope that helps.