关于12c中数据泵DataPump impdp导入工具增强
使用统一审计对所有impdp/expdp操作进行审计
例如:
CREATE AUDIT POLICY <policy_name> ACTIONS COMPONENT=DATAPUMP { EXPORT | IMPORT | ALL };
启用此策略
AUDIT POLICY <policy_name> BY SYSTEM;
你可以查询UNIFIED_AUDIT_TRAIL数据字典视图找到和Oracle Data Pump相关的审计事件:
SELECT DP_TEXT_PARAMETERS1, DP_BOOLEAN_PARAMETERS1 FROM UNIFIED_AUDIT_TRAIL WHERE AUDIT_TYPE = 'Datapump';
DP_TEXT_PARAMETERS1 DP_BOOLEAN_PARAMETERS1
---------------------------------------------- ----------------------------------
MASTER TABLE: SCOTT.SYS_EXPORT_TABLE_01, MASTER_ONLY: FALSE,
JOB_TYPE: EXPORT, DATA_ONLY: FALSE,
METADATA_JOB_MODE: TABLE_EXPORT, METADATA_ONLY: FALSE,
JOB VERSION: 12.1.0.0, DUMPFILE_PRESENT: