It's possible encrypting existing column without lost and rewrite data?
I've few milion of record and it's very important not lost data.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
From the documentation:
If an existing table has columns that require encryption, then use the ALTER TABLE command in the following form:
ALTER TABLE table_name MODIFY ( column_name column_type ENCRYPT,...);
The encryption process is atomic, and no data will be lost. The only way you'll lose the data is if you lose/destroy the wallet key, or drop the table/column yourself.