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?