1.创建审计策略
CREATE AUDIT POLICY audit_dp_all_pol ACTIONS COMPONENT=DATAPUMP ALL;
2.将策略应用到某个用户下
AUDIT POLICY audit_dp_all_pol BY SYSTEM;
3.执行导入导出相关的操作就会生成记录
SQL> ! expdp system/MyPassWord123 owner=C##ZHANGSAN1 file=/opt/oracle/product/18c/dbhome_1/rdbms/admin/C##ZHANGSAN1.dump
4.查询导入导出的操作记录
SELECT * FROM unified_audit_trail WHERE audit_type ='Datapump';
5.官网审计配置文档网址
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-audit-policies.html#GUID-75C42A70-E805-434E-8F22-B291C2B002C4