ORA-28073
The column "string" has an unsupported data type or attribute.
Cause
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, 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 datatypes are not supported: CLOB NCLOB BLOB BOOLEAN
- For DBMS_REDACT.RANDOM, the following datatypes are not supported: CLOB NCLOB BLOB
- For DBMS_REDACT.REGEXP, the following datatypes 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).
- Vector encoded columns are not supported by data redaction.
- Columns with the IS JSON constraint are not supported.
Action
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.