Unified_AUDIT_TRAIL does not show DataPump Parameters information

Dec 30, 2019 5:00AM

Problem Description

---------------------------------------------------

I created a audit policy for DataPump operations.

When expdp is run, the record is loaded into the UNIFIED_AUDIT_TRAIL, but no information about what was the schema exported or the table exported.

create audit policy PB_POL_DATAPUMP_OPS actions component=Datapump all;

Audit policy created.

15:05:05 SYS@PTPLD02D1 -> audit policy PB_POL_DATAPUMP_OPS;

Audit succeeded.

----

Datapump using sys as sysdba using parfile:

$ expdp \"/ as sysdba\" parfile=expdp_LPDBA_schema.par

Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

Database Security Products (MOSC)