ora_rowscn changing for non-updated rows?

From: <mh_at_pixar.com>
Date: 29 Jul 2009 23:23:01 GMT
Message-ID: <4a70d9d5$0$20316$576ef22_at_news.usenetserver.com>

I am inserting a row into a table, and seeing the ora_rowscn change for all the rows in the table.

1. Is this because all the (small) rows are in the same block, and the SCN is tied to the block?
2. Is there a better way of mapping the change time for a row, besided adding a timestamp column and updating that column in a trigger?

Many TIA!
Mark

desc a;
select ora_rowscn, a.* from a;
insert into a values(7);
commit;
select ora_rowscn, a.* from a;

Name Null Type
---- ---- ----

   A NUMBER(1) ORA_ROWSCN A
---------------------- ----------------------

14032868105            1                      
14032868105            2                      

ORA_ROWSCN             A                      


---------------------- ---------------------- 

14032868107            7                      
14032868107            1                      
14032868107            2                      

-- 
Mark Harrison
Pixar Animation Studios

Received on Wed Jul 29 2009 - 18:23:01 CDT