计划对varchar2(4000)的列进行加密，遇到ORA-283311
ORA-28331: encrypted column size too long for its data type
Cause: 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;
不过，直接把表放到加密表空间却不会报这个错。
11g的加密，多少有些华而不实。
阅读(144) | 评论(0) | 转发(0) |
