I work with ora_rowscn
to track the changed rows on a table and to work with updated rows.
Last week I noticed that for some (not all) of my tables that I created with rowdependencies
, the ora_rowscn
changes without any transactions on the table. I mean if I select max(ora_rowscn)
I get always higher number.
Here is an example how I created my table
creating table
create table test ( test_id number, txt varchar2(5) ) rowdependencies;
Inserted some data into the table
insert into test values(1,'a');
insert into test values(2,'b');
insert into test values(3,'c');
Queried the table more than once with ORA_ROWSCN
select max(ora_rowscn),max(b.current_scn) from test a, v$database b
Every time I queried I got a higher max(ora_rowscn)
.
On MetaLink i found two reported Bugs (Bug 14093863, Bug 9814923) that seems to be the same problem, but set as not a Bug.
Why does it happen and what is the solution to get it work or fix it?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…