TDE: ORA-01779 if primary key encrypted
The query is :
update
(select a.txt atx, b.txt btx from test1 a, test2 b where a.id = b.id)
set btx=atx;
Both tables (it's just a test case) are created by something alike:
create table test1 as select OBJECT_ID ID, OBJECT_NAME txt from all_objects where rownum < 101;
ID is primary key here:
alter table test1 add constraint test1_pk primary key (id);
If both tables are without TDE, all is fine: "100 rows updated.".
Now, I make primary key column encrypted (before creating the primary key):
alter table test3 modify (id encrypt using 'aes256' no salt);
(select a.txt atx, b.txt btx from test1 a, test2 b where a.id = b.id)
set btx=atx;
Both tables (it's just a test case) are created by something alike:
create table test1 as select OBJECT_ID ID, OBJECT_NAME txt from all_objects where rownum < 101;
ID is primary key here:
alter table test1 add constraint test1_pk primary key (id);
If both tables are without TDE, all is fine: "100 rows updated.".
Now, I make primary key column encrypted (before creating the primary key):
alter table test3 modify (id encrypt using 'aes256' no salt);
0