ORA-28338: Column(s) cannot be both indexed and encrypted with salt

<<Back to Oracle DB Security Main Page

SQL> CREATE INDEX employee_idx on ENC_TEST2 (empID);
CREATE INDEX employee_idx on ENC_TEST2 (empID)
                                        *
ERROR at line 1:
ORA-28338: Column(s) cannot be both indexed and encrypted with salt


Cause

You can not index a salted column

Solution:

Remove the SALT from the encrypted column in question and then create index on it.

SQL> ALTER TABLE ENC_TEST2 MODIFY (EMPID ENCRYPT NO SALT);
Table altered.
SQL> CREATE INDEX employee_idx on ENC_TEST2 (empID);
Index created.