2 Replies Latest reply: Apr 25, 2013 4:58 AM by InquisitiveDBA RSS

    Encrypting Columns and their corresponding Indexes

    InquisitiveDBA
      I have TDE on Oracle 11.2.0.2. I will encrypt the following tables:

      Table: APPS.ACCOUNTS
      Column: creditcard_num

      This is a primary key. It automatically has index. If I encrypt the column, using TDE column encryption, does the corresponding index automatically encrypted? Or I will have to encrypt the index as well?

      Table: APPS.SAVINGS
      Column: username
      Index: username_indx

      username is not a primary key but it has an index. If i encrypt the username column, will the index be encrypted as well.