Logminer will give you SQL that will duplicate the results of the DDL on a
row-by-row basis, but it will not tell you exactly what the original DDL
was. This is good for recovery, but not as good for auditing. It's up to
you to determine whether or not this is acceptable.
> From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
> Date: Tue, 26 Jul 2005 10:50:55 -0400
> Subject: Re: list of executed DML statements
>
> Lex is right and I was wrong.
>
> On 7/26/05, Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
>> in 9i, I guess the only option is using Logminer.
>> see the online documentation -- DBMS_LOGMNR and DBMS_LOGMNR_D packages.
>> hope this helps,
>>
>> Lex.
>>
>>> hello,
>>>
>>> is there any way (in Oracle DB 9.2i) to retrieve a list of all
>>> INSERTs, UPDATEs and DELETEs executed in specific time ago?
>>>
>>> thanks
>>> Dominik Smatana
Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich_at_pcci.edu
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 26 2005 - 10:02:54 CDT
