Skip to main content

Posts

To get the last time when table was updated

select scn_to_timestamp(max(ora_rowscn)) from OWNER.TABLE_NAME while running above query you can have error:- ERROR at line 1: ORA-08181: specified number is not a valid system change number ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 Cause: supplied scn was beyond the bounds of a valid scn. Action: use a valid scn. reason behind this can be:- This only works as long as the snapshot is still around. After that, it appears to go into a frozen state. All off my records older than a certain point have the same SCN. you can also use:- SELECT * FROM all_tab_modifications