Dimitry SibiryakovRTFM
Вот именно, RTFM:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
SQL> SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN)
2 FROM EMP
3 WHERE ENAME = 'KING'
4 /
SELECT SCN_TO_TIMESTAMP(ORA_ROWSCN)
*
ERROR at line 1:
ORA-08181: specified number is not a valid system change number
ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
SQL>
Notes:
The usual precision of the result value is 3 seconds.
The association between an SCN and a timestamp when the SCN is generated is remembered by the database for a limited period of time. This period is the maximum of the auto-tuned undo retention period, if the database runs in the Automatic Undo Management mode, and the retention times of all flashback archives in the database, but no less than 120 hours. The time for the association to become obsolete elapses only when the database is open. An error is returned if the SCN specified for the argument to SCN_TO_TIMESTAMP is too old.
Ну а максимум без flashback archives ~ 5 дней.
SY.
