| Author |
last modification on row
|
|
|
| Is there a way to discern when the last modification (update or insert) has
been performed on a row in a table? I have to work with a pre-existing table
structure, and cannot alter it. Thanks, Ike
| |
|
|
"Ike" <rxv@hotmail.com> wrote in message
news:3wRBe.5403$BK1.3879@newsread3.news.pas.earthlink.net...
> Is there a way to discern when the last modification (update or insert)
> has
> been performed on a row in a table? I have to work with a pre-existing
> table
> structure, and cannot alter it. Thanks, Ike
>
>
log miner
| |
| DA Morgan 2005-07-16, 3:23 am |
| Dave wrote:
> "Ike" <rxv@hotmail.com> wrote in message
> news:3wRBe.5403$BK1.3879@newsread3.news.pas.earthlink.net...
>
>
>
> log miner
Or with 10g with an active Flashback area ... a flashback query.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
| Mark D Powell 2005-07-18, 9:23 am |
| There is also a function ora_rowscn that can be used to approximate the
scn for a row. Once you have an scn that can be converted to a time
within 3 seconds using SCN_TO_TIMESTAMP.
You also have the option at table creation time to time to append an
scn to every row. This is called row level dependency and is intented
for use with replication but if you take action to save off the scn to
time data you could then use the saved data to perform scn to time
translaction.
If you really want the date/time the last change was made you should
probably either use the builtin audit feature or a DML trigger and a
history/audit table to capture this fact.
HTH -- Mark D Powell --
|
|
|
|