ORACLE 11g Know Insert Record Details which Failed to insert

by Shekhar Nalawade   Last Updated May 25, 2018 07:06 AM

I have started auditing insert records by user on failure to any table in my oracle 11g Database. I have used following command to do the same.

AUDIT INSERT ANY TABLE BY SHENA BY ACCESS WHENEVER NOT SUCCESSFUL;

I would like to know whenever the record insert will fail, Can i know what was the records which failed to insert into table.

Where we can see such information. Or if you know any other way of auditing of the same please suggest. One way which i know is to write a trigger on insert. In that trigger handle insert failure EXCEPTION and save those values to some table.



Related Questions


Is it safe to `TRUNCATE sys.aud$`?

Updated June 24, 2017 20:06 PM

Does `sys.aud$` recycle itself?

Updated June 24, 2017 20:06 PM



Query on schema profile resource values

Updated March 14, 2017 07:06 AM