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

Thread: trace DDL stmts

  1. #1
    Join Date
    Dec 2001
    Posts
    120

    trace DDL stmts

    Hi,

    Could someone pls help me find out the user name who dropped some of the tables from an oracle schema. We have not yet shutdown the db for recovery. This is just to find out how nearly 400 tables got dropped and the complete information about the session which dropped them.We are running in noarchivelog mode.

    thanking you,
    Parijat Paul

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    got auditing turned on, if not
    unlucky

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Log Miner?
    Assistance is Futile...

  4. #4
    Join Date
    Dec 2001
    Posts
    120
    since its a development database we dont have auditing and log miner set. Still doesn't oracle store this ddl stmts in some of the v$ views?

    Paul

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, why would it?

    that would be the purpose of auditing.

    Lesson learned then - you dont mention version - cant flashback?

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