select scn_to_timestamp(max(ora_rowscn)) from OWNER.TABLE_NAME
while running above query you can have error:-
ERROR at line 1:
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.
reason behind this can be:-
This only works as long as the snapshot is still around. After that, it appears to go into a frozen state. All off my records older than a certain point have the same SCN.
you can also use:-
SELECT * FROM all_tab_modifications
while running above query you can have error:-
ERROR at line 1:
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.
reason behind this can be:-
This only works as long as the snapshot is still around. After that, it appears to go into a frozen state. All off my records older than a certain point have the same SCN.
you can also use:-
SELECT * FROM all_tab_modifications
Comments
Post a Comment