Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Location
    London
    Posts
    3

    Unanswered: Reading Redo Logs

    Hi All,

    Currently playing around with extracting changes from source systems for use in a DataWarehouse. What I am wanting to do is extract all DML operations (Insert, Update, Delete) that have occured against tables by reading the redo log files.

    Has anyone done this or talk about their experience in trying this ?

    Regards,

    Ian.

  2. #2
    Join Date
    Nov 2001
    Posts
    25
    Provided Answers: 1
    If u r on 8i or above u can use logmnr tool.
    else u can dump the redo logs and check out for uodate,insert and delete codes , the data is in hex, so u will have to convert.

Posting Permissions

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