ORA-28337: the specified index may not be defined on an encrypted column
Cause: Index column was either a functional, domain, or join index.
Action: None
ORA- 28337 错误表示,在加密列上不允许定义索引。该错误对应于 ORACLE_HOME/rdbms/mesg/oraus.msg 文件中的一条错误消息:
*Cause: an Index was attempted to be created on an encrypted Column.
*Action: Index creation on an encrypted column is not allowed. Alerternatively, you can create the index on the DBMS_CRYPTO decrypted value of the encrypted column.
通常情况下,当您试图在加密列上创建索引时,就会发生此异常,应通过以下步骤来解决此错误:
1. 首先,请确保在加密列上不创建索引。
2. 为加密列解密值创建索引,可以使用 DBMS_CRYPTO 包或任何其他类似的解密函数。
3. 再执行 DML 操作,其中会将解密值更新到加密列。