How to fix the Oracle error ORA-28331: encrypted column size too long for its data type?

In this post, you’ll learn more about the Oracle ErrorORA-28331: encrypted column size too long for its data type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28331: encrypted column size too long for its data type

Reason for the Error ORA-28331: encrypted column size too long for its data type

column was encrypted and for VARCHAR2, the length specified was > 3932; for CHAR, the length specified was > 1932; for NVARCHAR2, the length specified was > 1966; for NCHAR, the length specified was > 966;

How to fix the Error ORA-28331: encrypted column size too long for its data type ?

You can fix this error in Oracle by following the below steps

Reduce the column size.