Why can't you use a global temporary table instead of creating/dropping this temporary table? -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Ron L. Sent: Monday, May 24, 2004 12:47 PM To: oracle-l@xxxxxxxxxxxxx Subject: Auditing how to. I have a monitoring script that runs every 15 minutes. It creates, and then deletes a temporary table each time it runs. I have turned on monitoring for all table DDL changes. I would like to exclude this table from the audit but I can't seem to get it to stop. Since the table only exists for a few seconds, I can't issue a noaudit on the specific object, only the user issuing the create command. Thanks! Ron=3D20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------