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.
Such partitioning is allowed but we recommend that you fully understand and accept the security concerns.
Note: This warning applies only to partitioning on the encrypted columns themselves.
Encrypted columns can be included in partitioned tables.
Last modified date: 08/14/2024