Hi, I have a question. Suppose if I want to check in a table how much data inserted/deleted or updated within two days then how to check. I mean suppose I am having a table abc and i inserted 200 rows today, after 2 or 3 days how to check how much data inserted/deleted or updated on that table abc. Please let me the solution

 Hi

Default Asked on August 31, 2018 in ORACLE.
Add Comment
1 Answer(s)

Dear ,

Ypu can check the same in dba_tab_modifications.

 

http://dbaclass.com/article/how-to-find-when-a-table-was-last-modified-in-oracle/

 

 

Regards

Newbie Answered on September 2, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.