Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    28

    Unanswered: how would I trace ddl?

    I have a couple of tables that's getting emptied out in the morning and I have no idea what process is doing it. I have placed on delete triggers which write to a trace table I created and insert sysdate, userid, tablename and action taken (delete) to catch if someone's running a delete on them however that won't help to track down if a truncate is being done. Any ideas on how I would set up a trace to capture truncates on specific tables from any user?

    Thanks for any ideas you could provide!!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    LOGMINER may provide clues
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jan 2004
    Posts
    28
    I appreciate all help, even smart-assed help.

    I have been googling for info (I wouldn't have posted before searching for myself) and reading on logminer, oracle audit, trace session etc that I could find. Let me expand on the problem a bit. The DBA is unavailable, and I (a developer) do not have dba nor sysadm privs which appears necessary to set up or start most of the database level tracing utilities I have found. With my limited role (schema level permissions) is there any way to identify ddl being run on a target object and capture who/when might be running it? Also the database is in noarchivelog mode so I think I need to capture the event at the point it occurs.
    Last edited by arobinson98; 05-19-09 at 17:36.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •