Oracle 19c – How to exclude AUDSYS schema data in a Datapump full export – it’s all about the filter

This post was originally published on this site

Why do we have AUDSYS data in our Oracle Data Pump full export? In a customer project, I was asked why there is always data of schema owner AUDSYS included in an Oracle Data Pump full export. The AUDSYS schema contains Unified Audit Trail Records and therefore the data is included when the feature is enabled. The demo case is a 19.15 Container Database with a PDB. The demo schema HR is loaded and there is a Unified Auditing Policy…

Posted in OCI

Leave a Reply

Your email address will not be published. Required fields are marked *