Oracle Data Redaction policies are created and applied at the PDB level, and only apply to objects in that PDB. You cannot create redaction policies in the CDB root.

You cannot create a Data Redaction policy for a multitenant container database (CDB); you can only create the Data Redaction policy at the PDB level. This is because the objects for which you create Data Redaction policies typically reside in a PDB.