Question: I have a table column that is a
BFILE BLOB column and I want to encrypt it. I have noted in
the documentation that you cannot use standard encryption for a
BFILE column. How do I encrypt a BFILE column that contains a
Answer: Yes, you are correct that
standard encryption cannot be used on BFILE (externally )
stored columns. Instead you need to use the
dbms_crypto procedure to store a BFILE. There only 3
data types supported by dbms_crypto, and they are RAW, BLOB
and CLOB, any of which can be a BFILE storage on a standard
OS flat file.
A BLOB can be either stored internally as a column, or
stored in an external file (BFILE).
For an example of
using DBMS_CRYPTO on BLOB data, see
"Example of Encryption and Decryption Procedures for BLOB