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.
Question
ORA_ROWSCN Where Oracle Stores the Time Row updated
+5
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:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.