Home » RDBMS Server » Server Administration » Finding last DML done for a table
Finding last DML done for a table [message #237945] Wed, 16 May 2007 03:22 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
How to find when is last DML operation has been done for a particular table?

Thanks.

Report message to a moderator

Re: Finding last DML done for a table [message #237949 is a reply to message #237945] Wed, 16 May 2007 03:32 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Two easy options:

1) Select from the table "AS OF TIMESTAMP"; or

2) Select from FLASHBACK_TRANSACTION_QUERY.

For examples, see http://www.orafaq.com/node/872

Report message to a moderator

Re: Finding last DML done for a table [message #237957 is a reply to message #237945] Wed, 16 May 2007 03:38 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Other ones:
- audit dml on the table
- Log Miner

Regards
Michel

Report message to a moderator

Previous Topic: Questions
Next Topic: Please help: ORA-03113
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:03:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.