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
when not matche then
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 184.108.40.206.0 - 64bit
Thanks in advance
I resolve problem, It's very strange!!!
I use TDE in name column when I create table1, but I alter table2 to encrypt column.
I have got ORA-28374 error when I use Merge.
I dropped table2 and I recreated it with TDE in colum.
So no problem when I use MERGE!!!