DROP AUDIT Clause

Use the DROP AUDIT clause with the ALTER TABLE command to remove it from the set of tables that is audited when selective row-level auditing is enabled.

The DROP AUDIT clause affects only tables that have been flagged for inclusion in selective row-level auditing. If you have not created or altered the table with the WITH AUDIT clause or ADD AUDIT clause, it is not necessary to use DROP AUDIT to exclude it from the set of tables that are audited at the row level.

Removing the AUDIT attribute from a table does not disable or change selective row-level auditing of other tables in the database.

You must be a DBSSO to run the ALTER TABLE command with the DROP AUDIT clause.