Logminer

[redouane]

السلام عليكم

set heading off;
set line 150;
spool file.sql;

@<oracle home>\rdbms\admin\dbmslm.sql
@<oracle home>\rdbms\admin\dbmslmd.sql

ALTER system SET utl_file_dir='c:\temp\' SCOPE=spfile;

shutdown immediate & startup

select 'EXECUTE Dbms_Logmnr.Add_Logfile( options => Dbms_Logmnr.AddFile, logfilename => ''I:\archive_save\ARC'||SEQUENCE#||'.001'');'
from v$log_history where FIRST_TIME between '20/08/2008' and '21/08/2008';

@file.sql;

execute Dbms_Logmnr.Start_Logmnr(dictfilename =>'dico.ora');

just an example

SELECT distinct SESSION_INFO
FROM v$logmnr_contents WHERE operation= 'UPDATE' AND seg_owner='PERS' AND seg_name='PERSONNEL';

بارك الله فيكم
وشكر سعيكم