find out who dropped the table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: find out who dropped the table

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi,
    One of my developers complained to me that one of the tables in her schema was missing. My question is that is there any way to find out who dropped the table and when? Any help would be appreciated.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Noway, unless audit enabled on users activity at session level.
    see what rsuri suggested works if you are using 8i. Follow this link on How to use Logminer.

    [url]http://www.oracle.com/oramag/oracle/99-Sep/59dba2.html[/url]

    [Edited by sreddy on 01-17-2001 at 06:58 PM]

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    You may try running Log Miner on the current Redo Logs (or archived logs if it has been archived); I am not sure though if DDLs are recorded there.

    - Rajeev

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