5.6 Oracle Data Redaction and Object Dependencies
Objects with dependencies will get recompiled, but you can proactively recompile them yourself.
If the base object that you want to add Data Redaction policies to has dependent objects, then these objects will become invalid when the Data Redaction policy is added to the base object, and these objects will be recompiled automatically when they are used.
Alternatively, you can proactively recompile them yourself by using an
ALTER ... COMPILE statement. Be aware that invalidating dependent
objects (by adding a Data Redaction policy on their base object) and causing them to
need to be recompiled can decrease performance in the overall system.
Tip:
Oracle recommends that you only add a Data Redaction policy to an object that has dependent objects during off-peak hours or during a scheduled downtime.