9. Using Data at Rest Encryption : Encryption and Partitioned Tables
 
Share this page                  
Encryption and Partitioned Tables
Partitioning on an encrypted column should be avoided because of a security issue: the partition into which each row is assigned will reveal how the plaintext value of the encrypted column tested against the partitioning rules. That is, some information can be inferred from the partition the row is in.
Although such partitioning is allowed, we recommend avoiding it unless the security concerns are well understood and accepted and the application design requires it.
Note:  This warning applies only to partitioning on the encrypted columns themselves.
Encrypted columns can be included in partitioned tables.