I am using the following query to get the most recent time that a table has been updated. i.e.
select to_char(scn_to_timestamp(max(ora_rowscn))) from scott.emp;
While I have never gotten the error below, another user is getting this error occasionally,
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
Does anyone have any idea of what could cause this error?
Is there a better way to get the most recent scn on an update to a table?
Thanks,
David