Last post Jul 18, 2011 08:08 AM by email@example.com
Jul 18, 2011 07:59 AM|pusnsuresh|LINK
How to find when table was last updated in Oracle.
Below query working fine in DEV Database the same is giving problem in PROD
select to_char(scn_to_timestamp(max(ora_rowscn))) from EMP
Getting below error in PROD
ORA-08181: SPecified number is not a valid system change number
Jul 18, 2011 08:08 AMfirstname.lastname@example.org|LINK
Check with the URL below:
This will help you get the last updated record from a table.
Thanks and Regards,