Error
Error Code: ORA-28071

Oracle Error ORA-28071

📦 Oracle Database
📋

Description

This error indicates an invalid ACTION parameter was used when attempting to alter a data redaction policy using the `DBMS_REDACT.ALTER_POLICY` procedure in Oracle Database. It occurs when the supplied action is not a supported type for modifying the redaction policy.
💬

Error Message

ORA-28071: The action is not valid.
🔍

Known Causes

3 known causes
⚠️
Invalid Action Parameter
The `ACTION` parameter specified in the `DBMS_REDACT.ALTER_POLICY` call is not one of the allowed values (e.g., `DBMS_REDACT.MODIFY_EXPRESSION`, `DBMS_REDACT.MODIFY_COLUMN`, `DBMS_REDACT.ADD_COLUMN`, or `DBMS_REDACT.DROP_COLUMN`).
⚠️
Typographical Error
A typo or incorrect spelling in the `ACTION` parameter value passed to `DBMS_REDACT.ALTER_POLICY` can cause this error.
⚠️
Incorrect API Usage
Attempting to use an action not supported by the current version of Oracle Database or the specific redaction policy can lead to this error.
🛠️

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