Home » SQL & PL/SQL » SQL & PL/SQL » ¿¿LAST_DML_TIME?? (Oracle 9i)
¿¿LAST_DML_TIME?? [message #352628] Wed, 08 October 2008 11:45 Go to next message
Nau
Messages: 24
Registered: October 2004
Junior Member
I want to know if there is anyway to know the date when a table have been updated in the
Oracle systems views.
Something like LAST_DDL_TIME (USER_OBJECTS) but of data (not structure), ¿¿LAST_DML_TIME??
Or something similar to LAST_ANALYZED but with data not statistics

Thanks in advance,
Re: ¿¿LAST_DML_TIME?? [message #352630 is a reply to message #352628] Wed, 08 October 2008 11:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No direct way unless you activated audit.
You can use Log Miner to mine your (archived) logs.

Regards
Michel

[Updated on: Wed, 08 October 2008 11:52]

Report message to a moderator

Re: ¿¿LAST_DML_TIME?? [message #352888 is a reply to message #352628] Fri, 10 October 2008 01:12 Go to previous message
saswatm
Messages: 2
Registered: June 2008
Junior Member
No direct way but you can put together a trigger to record the time when the table gets updated.


saswat
Previous Topic: NOT NULL COLUMN CARRY THE DEFINE VALUE
Next Topic: oracle 10g procedure ORA-06550 + PLS-00103
Goto Forum:
  


Current Time: Wed Feb 12 07:33:34 CST 2025