Database Administration (MOSC)

MOSC Banner

noaudit statement is not working !!!

edited Dec 12, 2013 10:25AM in Database Administration (MOSC) 17 commentsAnswered
Hi all,

I recently installed oracle 11gR2 database. lately I've been noticing large amount of records in aud$ table with action name delete on mdsys.sdo_geor_ddl_table$$ and other tables related to our application schema.

the deal is our application does alot of DELETE statements the whole time so it's a big headache to record all of them..

I tried noaudit delete on schema.tablename but no luck I also tried noaudit all on schema.tablename but no luck either it is still recording all the delete statements.

 

this is driving me crazy..please if any one can help I do appreciate it alot.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center