-
When data was last updated?
I wish to find out when my tables were last updated. Does monitoring on a table give you that? This is not last ddl date. Rather last DML time.
Thanks
Tuma
Looking for the greatest evil in the world? Look in the mirror.
-
-
Using LOGMINER you can find out when the table was last updated.
-
As a quick check, you can query ORA_ROWSCN from the table itself. The SCN can be converted to a timestamp with SCN_TO_TIMESTAMP.
-
Hi,
You can write a Trigger, which will update a column in the same table.......
say LUT column.......
Thx
sunil
-
thanks for the ideas..Much appreciated..
Looking for the greatest evil in the world? Look in the mirror.
-
Originally Posted by ebrian
As a quick check, you can query ORA_ROWSCN from the table itself. The SCN can be converted to a timestamp with SCN_TO_TIMESTAMP.
good one..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally Posted by ebrian
As a quick check, you can query ORA_ROWSCN from the table itself. The SCN can be converted to a timestamp with SCN_TO_TIMESTAMP.
As far as I remember this (SCN_TO_TIMESTAMP) works only for the last 5 days.
Also if ROWDEPENDENCIES is not enabled you will not see when a specific row but only when something within the DB block has been modified the last time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|