Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-28331

encrypted column size too long for the data type

Cause

The column was both encrypted and one of the following:

  • For VARCHAR2 when extended character data types were disabled, the length specified was greater than 3932.
  • For VARCHAR2 when extended character data types were enabled, the length specified was greater than 32699.
  • For CHAR, the length specified was greater than 1932.
  • For NVARCHAR2 when extended character data types were disabled, the length specified was greater than 1966.
  • For NVARCHAR2 when extended character data types were enabled, the length specified was greater than 16349.
  • For NCHAR, the length specified was greater than 966.
  • For RAW when extended character data types were disabled, the length specified was greater than 3932.
  • For RAW when extended character data types were enabled, the length specified was greater than 32699.

Action

Reduce the column size, or use TDE tablespace encryption.