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

Hello,

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

insert....

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 11.2.0.1.0 - 64bit

 

Thanks in advance

Legend

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