Hi,
is there a way of having a complete history of all datapump operations that have been performed ?
I researched everywhere and I couldn't find a way. I am interested to know if one of my databases daily export data pump operations have failed !
The only way I can to have such history is through auditing in Oracle 12c (unified auditing), for example:
CREATE AUDIT POLICY audit_datapump ACTIONS COMPONENT=DATAPUMP EXPORT;
AUDIT POLICY audit_datapump BY PUMP_EXP_ACCOUNT;
then querying:
SELECT event_timestamp,
dp_text_parameters1,
dp_boolean_parameters1
FROM unified_audit_trail
WHERE audit_type = 'Datapump';
but there is no information provided that the datapump operation was FAILED or SUCCESSFUL ?!!
any thoughts ?!
Thanks,
Emad