Error
Error Code: ORA-28064

Oracle Error ORA-28064: Invalid Redaction Type

📦 Oracle Database
📋

Description

The ORA-28064 error occurs in Oracle Database when attempting to add a data redaction policy using `DBMS_REDACT.ADD_POLICY` with an invalid `FUNCTION_TYPE` parameter. This indicates that the specified redaction method is not supported or misspelled.
💬

Error Message

The redaction function is not valid.
🔍

Known Causes

3 known causes
⚠️
Invalid FUNCTION_TYPE value
The `FUNCTION_TYPE` parameter in `DBMS_REDACT.ADD_POLICY` was set to a value that is not recognized as a valid redaction type.
⚠️
Incorrect Redaction Type for Data Type
The selected `FUNCTION_TYPE` is incompatible with the data type of the column being redacted (e.g., using `DBMS_REDACT.RANDOM` on a `BLOB` column).
⚠️
Typographical Error in Function Name
A typo exists in the `FUNCTION_TYPE` parameter, causing Oracle to be unable to identify the intended redaction function.
🛠️

Solutions

Coming Soon

Detailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:

General Troubleshooting Tips

  • Check the error message carefully for specific details
  • Review recent changes that might have caused the error
  • Search for the exact error code in the official documentation
  • Check log files for additional context
  • Try restarting the application or service

Find Help

Stack Overflow Google Search Official Docs