Urgent! tables are dropped
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Urgent! tables are dropped

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    I have a urgent quesion, I just find out that some of the tables are missing in my production database. Is there any way I can easily find out who did it? By the way, I do not have triggers on the tables. Any input would be appreciated. Thanks a million!

    Dragon

  2. #2
    Join Date
    Nov 2000
    Posts
    205
    Logminer???? I have not used it yet, and not sure it works with DDL.

    Good luck,
    Nirasha

  3. #3
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Sorry, my db is 8.1.5E.E. logminer starts with 8.1.6? I guess

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Per jmodic, you can still do it...

    http://www.dbasupport.com/forums/sho...?threadid=9215

    HTH,

    - Chris

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by dragon99
    Sorry, my db is 8.1.5E.E. logminer starts with 8.1.6? I guess
    Logminer was introduced in 8.1.5, so you are ready to go....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Aug 2000
    Posts
    462
    logminer was introduced with 8i, but will work on any Oracle 8 or newer database.

  7. #7
    Join Date
    Mar 2001
    Posts
    61
    just wondering does logminer records DDL's as well??

  8. #8
    Join Date
    Nov 2000
    Posts
    344
    Yes I believe it does.

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, not directly, only indirectly. When executing DDLs, database dictionary tables are updated, inserted or deleted and those dictionary DMLs are logged. So you actually won't find any 'DROP TABLE ...' in your log miner output, but you'll find "INSERT INTO sys.obj$ (obj#, dataobj#, owner#, name, ...) VALUES(...)"
    in the SQL_REDO of the logminer output. So you'll be looking for the above statements where column NAME will reference your dropped table name.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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