Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question on error getting a table's most recent scn

DavidBardwell-OracleAug 21 2014 — edited Aug 21 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2014
Added on Aug 21 2014
5 comments
534 views