Database Error Messages

The command referenced a redacted column in an object protected by a data redaction policy.

Do one of the following and then retry the operation:

• Modify the command to avoid referencing any redacted columns.
• Drop the data redaction policies that protect the referenced tables and views.
• Ensure that the user issuing the command has the EXEMPT REDACTION POLICY system privilege.

The EXEMPT REDACTION POLICY system privilege is required for:

• Creating or refreshing a materialized view when the materialized view is based on an object protected by a data redaction policy.
• Performing a data pump schema-level export including any object protected by a data redaction policy.
• DML or DDL operations if a column with data redaction policy appears as the source.
• Creating mining models on tables that have a column with data redaction policy as internally Oracle Data Mining issues DDL and DML statements.

All data redaction policies are listed in the REDACTION_COLUMNS catalog view.

The command referenced a redacted column in an object protected by a data redaction policy.

If possible, modify the command to avoid referencing any redacted columns. Otherwise, drop the data redaction policies that protect the referenced tables and views, or ensure that the user issuing the command has the EXEMPT REDACTION POLICY system privilege, then retry the operation. The EXEMPT REDACTION POLICY system privilege is required for creating or refreshing a materialized view when the materialized view is based on an object protected by a data redaction policy. The EXEMPT REDACTION POLICY system privilege is required for performing a data pump schema-level export including any object protected by a data redaction policy. All data redaction policies are listed in the REDACTION_COLUMNS catalog view.

The command referenced a redacted column in an object protected by a data redaction policy.

If possible, modify the command to avoid referencing any redacted columns. Otherwise, drop the data redaction policies that protect the referenced tables and views, or ensure that the user issuing the command has the EXEMPT REDACTION POLICY system privilege, then retry the operation. The EXEMPT REDACTION POLICY system privilege is required for creating or refreshing a materialized view when the materialized view is based on an object protected by a data redaction policy. The EXEMPT REDACTION POLICY system privilege is required for performing a data pump schema-level export including any object protected by a data redaction policy. All data redaction policies are listed in the REDACTION_COLUMNS catalog view.