upgrading to Oracle 10g and using
CREATE TABLE ... ROWDEPENDENCIES.
That would be better called last touched, not inserted, because for example updates also affects ora_rowscn.
[@more@]create table tt(id number);
insert into tt values(1);
select ora_rowscn from tt;
commit;
select ora_rowscn from tt;
insert into tt values(2);
select ora_rowscn from tt;
commit;
select ora_rowscn from tt;
create table ttt (id number) rowdependencies;
insert into ttt values(1);
select ora_rowscn from ttt;
commit;
select ora_rowscn from ttt;
insert into ttt values(2);
select ora_rowscn from ttt;
commit;
select ora_rowscn from ttt;
select to_char(scn_to_timestamp(ora_rowscn),'yyyymmdd hh24:mi:ssxff') from ttt;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12402/viewspace-914144/ ，如需转载，请注明出处，否则将追究法律责任。
