|How to find FGA, [message #468823]
||Mon, 02 August 2010 04:53
Registered: February 2008
We were receving ERROR ORA-01401: inserted value too large for column FROM our Application on table finance1 IN SCHEMA MOON.
To Audit we start Auditing on insert on this table by following
object_schema => 'MOON'
,object_name => 'FINANCE1'
,policy_name => 'AUDIT_FINANCE1'
,audit_condition => NULL
,audit_column => 'COMMENTS'
,handler_schema => NULL
,handler_module => NULL
,enable => TRUE
,statement_types => 'INSERT'
,audit_trail => DBMS_FGA.DB_EXTENDED
,audit_column_opts => DBMS_FGA.ANY_COLUMNS
After above audit started, there was ORA-01401 error generated
But the main problem is, when look at the table dba_fga_audit_trail, we are unable to find Error insert audit record because the size of field value are ok.