Enable auditing for datapump jobs - Oracle Database Script. -- Create policy create audit policy expdp_aduit actions component=datapump export; -- Enable policy audit policy expdp_aduit; -- View audit report: select DBUSERNAME,DP_TEXT_PARAMETERS1 from UNIFIED_AUDIT_TRAIL where DP_TEXT_PARAMETERS1 is not null;
-- Create policy create audit policy expdp_aduit actions component=datapump export; -- Enable policy audit policy expdp_aduit; -- View audit report: select DBUSERNAME,DP_TEXT_PARAMETERS1 from UNIFIED_AUDIT_TRAIL where DP_TEXT_PARAMETERS1 is not null;