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

    Encrypting Columns and their corresponding Indexes

      I have TDE on Oracle 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.