Trying to run the following SQL which is basically an exact copy of an example I have seen on multiple sites, showing how to do this (I just change the tablename)
SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN) AS scn_time, ... FROM TABLE_ONE WHERE ...;
But when I run it, it returns this error:
ORA-08181: specified number is not a valid system change number ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 08181. 00000 - "specified number is not a valid system change number" *Cause: supplied scn was beyond the bounds of a valid scn. *Action: use a valid scn.
What can I change to get this working? I am just looking to find the date/time a row was last updated.
Cheers in advance