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 inserted/updated since a certain time.
( Sort of find ... -mtime ... for UNIX files) .
I CAN NOT modify the structure of the table , i.e. i CAN NOT add a
timestamp or other
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 ?
of list ORACLE-L [EMAIL PROTECTED]
Subject: A modification time question
Date: Thu, 16 Aug 2001 03:15:49 -0800
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 inserted/updated since a certain time.
( Sort of find ... -mtime