1 Reply Latest reply: Feb 13, 2014 2:37 AM by Moonlight RSS

"ORA-28374: typed master key not found in wallet" With MERGE

Moonlight Newbie
Currently Being Moderated


I create two tables(table1, table2) both are encrypted with TDE in column "name".

when i guess to use merge for load data, a message error is produced ORA-28374: typed master key not found in wallet!!

merge into table1 a

           using table2 b

         on (a.code1=b.code1)

when not matche then


values ...


But when, i user insert, no problem


I need to use merge to ckeck data befor insert. Any one know why with merge this errors is produced? and who can I correct it?

My oracle version is - 64bit


Thanks in advance


  • Correct Answers - 10 points
  • Helpful Answers - 5 points