Logminer Problems

متابعين

بتاريخ: 12 أكتوبر 200916 سنة

السلام عليكم
أرجو أن أحصل علي جواب منكم
إليكم الأكواد

EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => 'F:\archive_backup\arc00001_0673546318.001',OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => 'F:\archive_backup\arc00002_0673546318.001',OPTIONS => DBMS_LOGMNR.ADDFILE);

EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

SQL> select USERNAME,session_info, sql_redo
2 from V$LOGMNR_CONTENTS
3 where table_name='MIN_NATURE_MINERAI'
4 and operation='DELETE';

UNKNOWN,UNKNOWN
delete from "SIGM_P"."MIN_NATURE_MINERAI" where "ID" = 'BNDG_0000004279' and "SU
BSTANCE" = 'Agt' and "MINERAI" = 'A25' and "PRODUCTION_PASSEE" = '0' and "RESERV
E" = '0' and "QUALIFICATIF_RESERVE" IS NULL and "RESSOURCE" = '0' and "QUALIFICA
TIF_RESSOURCE" IS NULL and "TENEUR_MOYENNE_PRODUCTION" IS NULL and "TENEUR_MOYEN
NE_RESERVE" IS NULL and "TENEUR_MOYENNE_RESSOURCE" = '.80000000000000004' and "U
NITE_TENEUR" = '%' and "ANNEE_INF_PROD_PASSEE" IS NULL and "ANNEE_SUP_PROD_PASSE
E" IS NULL and "ANNEE_RESERVE" IS NULL and "ANNEE_RESSOURCE" = '1980' and "AUTEU
R" = 'SIGM_P' and "DATE_CREATION" = TO_DATE('28-SEP-09', 'DD-MON-RR') and "DATE_
MODIFICATION" = TO_DATE('28-SEP-09', 'DD-MON-RR') and "OBJECTID" IS NULL and ROW
ID = 'AAAMrXAAFAAAAS9AAA';