dbms_logmnr.start_logmnr(options=>dbms_logmnr.ddl_dict_tracking);
---If the LogMiner dictionary in use is a flat file or in the redo log files, LogMiner updates
ts internal dictionary if a DDL event occurs. dbms_logmnr.start_logmnr(options=>dbms_logmnr.DICT_FROM_ONLINE_CATALOG); --using current online database dictionary SYS@lmis> select /*+ first_rows */ sql_redo,object_id from v$Logmnr_contents w ere operation='DIRECT INSERT' and table_name = 'OBJ# 202096' and rownum < 3 ; SQL_REDO ------------------------------------------------------------------------------- OBJECT_ID -------------------------------- insert into "UNKNOWN"."OBJ# 202096"("COL 1","COL 2","COL 3","COL 4","COL 5","CO 6","COL 7","COL 8","COL 9","COL 10","COL 11","COL 12","COL 13","COL 14","COL 1 ","COL 16","COL 17","COL 18","COL 19","COL 20","COL 21","COL 22","COL 23") valu s (HEXTORAW('c447151345'),HEXTORAW('78740502110230'),HEXTORAW('bcf0bbf5bcc7d5ca ),HEXTORAW('4457493030363738313931'),HEXTORAW('4457493030333930333031'),HEXTORA ('434b443035303032313633343133'),HEXTORAW('5350483030303433343032'),HEXTORAW('4 57493830313131333739'),HEXTORAW('4d303032393234'),HEXTORAW('31'),NULL,HEXTORAW( 3d6466'),HEXTORAW('80'),HEXTORAW('c129'),HEXTORAW('80'),HEXTORAW('80'),HEXTORAW '80'),HEXTORAW('80'),HEXTORAW('c30c3f34'),HEXTORAW('c20534'),HEXTORAW('c20234') "UNKNOWN"."OBJ# 202096"这些表示被删除，或是对像不存在的