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

Thread: logs

  1. #1
    Join Date
    Jan 2003
    Posts
    38

    logs

    Hi All,

    Is there a way to check when a particular table was last modified and by which user.

    I had entered some data in a table and that column now is empty and I need to find out the cause so please let me know if there is a way to check what time the table was edited.

    Any help is highly appreciated

    Thanks
    -K

  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    LogMiner or enable auditing




    F.

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Also an UPDATE,INSERT,DELETE trigger on the table, that captures the modified data and the Oracle user, and inserts it into an "AUDIT" table.
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Now since you want to see what already has happened, you can look into Logminer (if you have 8i onwards database).

    To avoid such problems in future, you can use object level triggers, like DELETE trigger.
    Agasimani
    OCP(10g/9i/8i/8)

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