the answer is it depends. since you can't modify the table, why not
put a trigger to put a last updated, etc time into another table.
joe
Andrey Bronfin wrote:
Dear gurus !
Is there a way to know the time of insert/update for each row in a table ?
Or , which rows in a table were
Hi Aviv !
Thanks for your reply !
Yes , i thought of this snapshot log option .
2 problems :
1) performance overhead - for each DML on my table , i have a DML on the
MLOG$_ (snapshot log) table , carried out by a trigger.
2) For each access to the rows in my original table , i need to join with
If you can't modify the structure to add a timestamp column or add a
trigger to insert a timestamp into another table, there's no way I know
of to track it. Oracle doesn't track this sort of thing on its own; you
need some sort of timestamp field.
Jon Walthour
-Original Message-
Bronfin
Create a trigger on insert/update of zour table and let the trigger write
tuple in other table with datetime of modification of ROWID of your table.
Jan Pruner
Dne èt 16. srpen 2001 13:15 jste napsal(a):
Dear gurus !
Is there a way to know the time of insert/update for each row in a table ?
Okay, can you add a trigger?
At a prior job, management wanted us not only to track last update/insert
but WHAT was done.
so I created a second table, duplicate of the first with addition fields of
trans_date,user and action
then I added a trigger (insert/update/delete) on the original