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

Thread: Data getting deleted from Table Unexpectedly every Wednesday Morning

  1. #1
    Join Date
    Feb 2015
    Posts
    1

    Question Data getting deleted from Table Unexpectedly every Wednesday Morning

    Team,

    I have a peculiar situation where Data from a Oracle Table is getting deleted unexpectedly every wednesday morning. Now, we checked if there is any deleted script scheduled to run on that 'table' but found that there were none. Can you please provide some pointers for us to explore more?

    Regards,
    Vikram

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You should also check for cron/system schedule jobs. If you can't figure it out,
    then you should turn on auditing for deletes on the table in question.

    http://docs.oracle.com/cd/E11882_01/...htm#TDPSG50524

    Either there is a stored procedure gone wrong, or someone is doing something that they should not do.

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