History of a particular table in oracle

Question

Is it possible to find the history of values, updates, deletions or inserts of a specific table?

I do not have access to create stored procedure. Could you provide me with a response request or some other way to find the story?

Answer 1

Two possibilities come to mind.

1.) If you have auditing enabled, you are all set up. But, I think, if that were the case, you would not ask a question. If you think this request will appear again, you should investigate the audit setup for future requests.

2.) , LogMiner, - . , , , , , .

, .

Answer 2

, FLASHBACK . . . DBA, SQL Developer, Shift+F4 Flashback, .

, ( )

SELECT * FROM employee AS OF TIMESTAMP 
   TO_TIMESTAMP('2003-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')
   WHERE name = 'JOHN';

, TRIGGERS evry DML . , TRIGGERS , DBA ...!

Answer 3

Is this what you are looking for? http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2103.htm