Foreign Keys in Encrypted Tablespaces (TDE)
Oracle 10g TDE did not allow you to encrypt columns that were foreign keys. From Adv. Security doc:
You cannot use transparent data encryption to encrypt columns used in foreign key
constraints. This is because every table has a unique column encryption key.
With 11g, TDE supports encrypted tablespaces. I can move a table containing foreign key columns into an encrypted tablespace. I don't seem to have any issues with inserting/updating the table or joining it to non-encrypted tables by the foreign key. I couldn't find anything in the Oracle Advanced Security documentation for 11g that says it is acceptable to use TDE to move a table with foreign keys into an encrypted tablespace. Does the fact that each table has a unique column encryption key only matter when you are encrypting select columns and not when working with encrypted tablespaces?