Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find out when an Oracle table was updated the last time?

2897865Mar 5 2015 — edited Mar 5 2015

I want to findĀ  when the last INSERT, UPDATE or DELETE statement was performed on a table (for now, in the future I want to do this in multiple tables) in an Oracle database.

I created a table and then I updated one of it's rows. Now I've the following code:

SELECT ORA_ROWSCN, * FROM test_table;

SELECT SCN_TO_TIMESTAMP(ora_rowscn) from test_table;

This code, presents me the timestamps of each row but from the time when they were firts created. The row which I updated, have the same time stamps of the others. Why?

Can someone help me please?

This post has been answered by unknown-7404 on Mar 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2015
Added on Mar 5 2015
2 comments
9,989 views