Is it possible to change a database from having no encryption to having simple encryption using the CREATE ENCRYPTED FILE command? Or must you use dbunload or dbinit flags and create a new database file?
asked 15 Nov '11, 17:37
Starting with 11.0.1, you can use the CREATE ENCRYPTED DATABASE statement to create a new database (with all necessary files) from a not encrypted (or differently encrypted one). That does not require a reload.
As to the docs, that does also allow to change from no encryption to simple encryption.
EDIT 1: To answer your actual question, the same should be possible in older versions with CREATE ENCRYPTED FILE (so you should not need to do an unload) - but you have to take care to adapt all necessary files yourself.
EDIT 2: As Graeme has pointed out, CREATE ENCRYPTED FILE does not support simple encryption. So I stand corrected...