RE: Strange Flashback Query Behaviour
From: Matt McClernon <mccmx_at_hotmail.com>
Date: Mon, 13 Feb 2012 11:26:04 +0000
Message-ID: <BAY171-W113AED7925CCD2A08DCC34EB77F0_at_phx.gbl>
> For each row, ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to the row in the current session. This pseudocolumn is useful for determining approximately when a row was last updated. It is not absolutely precise, because Oracle tracks SCNs by transaction committed for the block in which the row resides.
Date: Mon, 13 Feb 2012 11:26:04 +0000
Message-ID: <BAY171-W113AED7925CCD2A08DCC34EB77F0_at_phx.gbl>
> For each row, ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to the row in the current session. This pseudocolumn is useful for determining approximately when a row was last updated. It is not absolutely precise, because Oracle tracks SCNs by transaction committed for the block in which the row resides.
Thanks for the info. But my concern is that the VERSIONS_STARTSCN/XID is null for the insert. I only used ORA_ROWSCN to determine roughly when that row was inserted. My VERSIONS BETWEEN query returns suspicious results, and I cannot seem to query the data at an SCN which is after the CREATE TABLE but before the INSERT.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 13 2012 - 05:26:04 CST