DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: LogMiner question

  1. #1
    Join Date
    Oct 2001
    Posts
    13
    Hi,

    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 =
    'AAAH2pAABAAA8C6AAC';
    insert into "UNKNOWN"."OBJ# 32169"("COL 1") values (HEXTORAW('c115'));

    Can anyone suggest how to get the result in normal ascii format.

    Thanks ,
    Sreelatha

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    use GUI of LogMiner.
    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

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You should build the dictionary file before starting log miner to resolve the HEX names to the readable format.

    Sanjay

  4. #4
    Join Date
    Nov 2000
    Posts
    56

    Red face

    Yep, sanjay is right.


    Rama

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width