ddlgen and Encryption

You can use the ddlgen utility with both encrypted columns and encrypted databases.

ddlgen provides support for both encrypted databases and encrypted columns.

For databases, use ddlgen to:
  • Create an encrypted database
  • Create a database encryption key
ddlgen adds support for transparent database encryption with these values for the -TEK parameter:
  • -XOCE – only generate DDL from column encryption keys
  • -XOMK – only generate DDL from master key or dual master key
  • -XODE – only generate DDL from database encryption keys (dek)