I use logminer parsing redolog found that the precision of the timestamp field, lost only to the second, at the back of the ms is 0, as shown in figure

This is the result:


This is the original table:


This is I set the parameters of the
Alter session set nls_date_format='YYYY - MM - DD HH24: MI: SS';
Alter session set NLS_TIMESTAMP_FORMAT='YYYY - MM - DD HH24: MI: SS: ff6';

What reason is this excuse me?

CodePudding user response:

Add that the database is 10 g

CodePudding user response:

Really didn't notice this, but if is the instance recovery, with the SCN number is ok