Column encryption use-case

     I think your biggest issue with encrypting your data will be with data types.  You may have to change from a CLOB to a BLOB/RAW and drop all of the indexes on that column.  You'll also have to discuss this with the app developer since once encrypted they will need to decrypt the data before they can use it which will mean they need the encryption key stored somewhere and if that's hard coded it will be a pain when it needs changing and having it in a view definition would negate the effect of having encryption.

Richard Goulet
Retired DBA

--
http://www.freelists.org/webpage/oracle-l