RMAN Catalog 12.1 cannot be exported without EXEMPT ACCESS POLICY
RMAN: 12.1.0.2
Database 12.1.0.2
I created the RMAN Catalog 12.1 in its own schema (RMAN_CAT_12) in a 12.1.0.2 database with the CREATE CATALOG command. It's working well.
I run nightly exports of the entire database.
Now that I've added the catalog to this database, the expdp fails with multiple ORA-39181: Only partial table data may be exported due to fine grain access control on "RMAN_CAT_12".<object>.
Talks about how to get around this by granting system privilege EXEMPT ACCESS POLICY to the user exporting the schema.
The exports are done as SYSTEM, so I did so. It now works.