I have configured log miner.
When I select from v$logmnr_contents table as
select scn,sql_undo,sql_redo from v$logmnr_contents
I get result in hexadecimal codes as follows
delete from "UNKNOWN"."OBJ# 32169" where "COL 1" = HEXTORAW('c115') and ROWID =
insert into "UNKNOWN"."OBJ# 32169"("COL 1") values (HEXTORAW('c115'));
Can anyone suggest how to get the result in normal ascii format.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
You should build the dictionary file before starting log miner to resolve the HEX names to the readable format.
Click Here to Expand Forum to Full Width