How to Find
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to Find

  1. #1
    Join Date
    Jan 2003
    Posts
    33

    How to Find

    Datebase: Oracle 8i R8.1.6
    OS : HP Unix 11.0

    How we can find who has deleted the records from a table and when . Only thing we know at this point is name of the Table.

    TKPROF is not turned ON and also Trace is not Turned ON Specifically. Is there any Log file generated by Oracle to see from that.

    One way is by using Log Miner.

    If any one knows any other way pls do share.

    Thanks for the knowledge sharing.

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    only other way I can think of is auditing if turned on.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    As Sureshy says if you don't have auditing switched on then log miner is your only option.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Logminer is probably the best way. You can use http://www.oracle-base.com/Articles/8i/LogMiner.asp to find out how to use it...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    And for the cows that haven't left the barn, you can use triggers to capture DML (the who and when of it, not the actual DML) on key tables.

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