Skip to main content

This might be useful in tables where rowvesrion doesn’t store this information. But, does anyone have clue as to why

SELECT TIMESTAMP_TO_SCN(SYSDATE) FROM DUAL;

works but

SELECT TIMESTAMP_TO_SCN(SYSDATE + 15) FROM DUAL;

doesn’t?

​​​​​​​Thank you.

The SCN, system Change Number, is not possible to use in the future. (Only a few seconds in the future seems to work when I test.) I can’t see why you need to do that since no records that exists now are changed in the future?

 

Also, the SCN seems only to be remembered a while so you can’t convert it for too old SCN’s.

Especially the “Note” section in the Oracle documentation below describes how it is remembered:

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TIMESTAMP_TO_SCN.html#GUID-58796E1A-9943-4966-96E6-78B636BD2859

Reply


Terms & ConditionsCookie settings