Database Error Messages

The column has a data type or attribute that is not supported by data redaction. The supported data types are CHAR, NCHAR, VARCHAR2, NVARCHAR2, NUMBER, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP, CLOB, NCLOB, BLOB, and BOOLEAN except as listed below for certain function types:

• For DBMS_REDACT.PARTIAL, the following data types are not supported: CLOB NCLOB BLOB BOOLEAN

• For DBMS_REDACT.RANDOM, the following data types are not supported: CLOB NCLOB BLOB

• For DBMS_REDACT.REGEXP, the following data types are not supported: NUMBER BINARY_FLOAT BINARY_DOUBLE DATE TIMESTAMP BLOB BOOLEAN

• Virtual columns and base columns of virtual columns are not supported by data redaction.

• Columns with the INVISIBLE attribute are not supported by data redaction (this applies to both user specified hidden columns and system generated hidden columns).

• Columns with the IS JSON constraint are not supported.

Specify the name of a column that has a supported data type and supported attributes. For columns with the IS JSON constraint, create a view on the columns and add the redaction policy to the view.

The column had a data type or attribute which is not supported by data redaction. The supported data types are CHAR, NCHAR, VARCHAR2, NVARCHAR2, NUMBER types, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP, CLOB, NCLOB, and BLOB, except as listed below for certain function types: For DBMS_REDACT.PARTIAL and DBMS_REDACT.RANDOM, the CLOB, NCLOB, and BLOB datatypes are not supported. For DBMS_REDACT.REGEXP, the NUMBER, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP, and BLOB datatypes are not supported. Virtual columns and base columns of virtual columns are not supported by data redaction. Columns with the INVISIBLE attribute are not supported by data redaction (this applies to both user-specified hidden columns and system-generated hidden columns). Vector encoded columns are not supported by data redaction. Columns with the IS JSON constraint are not supported.

Specify the name of a column which has a supported data type and supported attributes. For columns with the IS JSON constraint, create a view on the columns and add the redaction policy to the view.

The column had a data type or attribute which is not supported by data redaction. The supported data types are CHAR, NCHAR, VARCHAR2, NVARCHAR2, NUMBER types, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP, CLOB, NCLOB, and BLOB, except as listed below for certain function types: For DBMS_REDACT.PARTIAL and DBMS_REDACT.RANDOM, the CLOB, NCLOB, and BLOB datatypes are not supported. For DBMS_REDACT.REGEXP, the NUMBER, BINARY_FLOAT, BINARY_DOUBLE, DATE, TIMESTAMP, and BLOB datatypes are not supported. Virtual columns and base columns of virtual columns are not supported by data redaction. Columns with the INVISIBLE attribute are not supported by data redaction (this applies to both user-specified hidden columns and system-generated hidden columns). Vector encoded columns are not supported by data redaction. Columns with the IS JSON constraint are not supported.

Specify the name of a column which has a supported data type and supported attributes. For columns with the IS JSON constraint, create a view on the columns and add the redaction policy to the view.