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

Thread: How to Find

  1. 01-06-2003, 11:26 AM #1
    oraclekb
    oraclekb is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 01-06-2003, 11:42 AM #2
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
  3. 01-06-2003, 11:51 AM #3
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  4. 01-06-2003, 11:52 AM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  5. 01-06-2003, 12:59 PM #5
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width