ORA-55940: An error occurred during execution of ktliIngestExternData

This will be a short blog post about an issue i have faced the other day, i was trying to query unified audit trail view:

SQL> select * from unified_audit_trail;

ORA-55940: An error occurred during execution of ktliIngestExternData

This error is related to unified audit spill over files located in $ORACLE_BASE/audit/ORACLE_SID

so you have two options:

OPTION 1: upload them  by executing:

exec DBMS_AUDIT_MGMT.LOAD_UNIFIED_AUDIT_FILES;

OPTION 12: remove the spill over files if you think this will not impact your security (use rm Linux OS command)

restart your database and try querying again unified_audit_trail