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.

  • 2
    Why would you lose any data?
    – Philᵀᴹ
    Oct 14 '16 at 9:16
  • I do not know if they get lost. but I must avoid it.
    – ciro
    Oct 14 '16 at 9:18
  • There is always someone Putting a negative vote without explaining the reason
    – ciro
    Oct 14 '16 at 10:30

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.

  • documentation is related to version 11. I have 10. I assume that the same applies under. thanks
    – ciro
    Oct 14 '16 at 10:36

Rather than encrypting you can make the table READ ONLY through the following statement:


Then no DDL or DML operations will affect the table.

  • i need encryption with Transparent Data Encryption
    – ciro
    Oct 14 '16 at 10:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.