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

Thread: user object dropped

  1. 02-11-2002, 03:31 AM #1
    shashikumar
    shashikumar is offline Junior Member
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38

    Red face

    hi all,
    some one has dropped all objects of a user in the database.
    Is there any way to know who has dropped it.

    oracle 8i
    win nt 4.0
    non archive log mode



    [Edited by shashikumar on 02-11-2002 at 02:33 AM]
    Reply With Quote Reply With Quote
  2. 02-11-2002, 04:23 AM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, not unless:

    a) you have auditing turned on
    b) the online redo log file(s) that were active during the drop commands have not been overwritten yet. In this case you could get that information from redo logs using logminer.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  3. 02-11-2002, 08:08 AM #3
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Jurij,

    Logminer can also be used for archived log files can't it ?

    So if you are in Archive log mode and know around the time the objects were dropped, you can also use logminer to mime archived log file.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.
    Reply With Quote Reply With Quote
  4. 02-11-2002, 08:36 AM #4
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    If you did not restart your databse yet, try to use views:
    v$sqlarea and v$sqltext to find out DDL statement and userid.
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  5. 02-11-2002, 10:37 AM #5
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Sureshy
    Jurij,

    Logminer can also be used for archived log files can't it ?
    The original poster explicitely stated: "non archive log mode".

    So there can not be any archlog files to be used with logminer. So he can only feed logminer with only online rodolog files.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    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