{暗号化}暗号化列を含む表をエクスポート/インポート

 

https://docs.oracle.com/cd/F19136_01/asoag/using-transparent-data-encryption-with-other-oracle-features.html#GUID-15CB716C-74A5-42E5-9BCA-7EC9C9FFA712

select * from v$encryption_wallet;

select * from all_encrypted_columns;

insert into sh.enca values('A1','B1',1,100);
insert into sh.enca values('A2','B2',2,200);
commit;

select * from sh.enca;

expdp system/oracle@orcl directory=ORA_DIR dumpfile=enca.dmp tables=sh.enca

expdp system/oracle@orcl directory=ORA_DIR dumpfile=enca2.dmp tables=sh.enca reuse_dumpfiles=yes ENCRYPTION=ENCRYPTED_COLUMNS_ONLY ENCRYPTION_PWD_PROMPT = YES

 

select * from v$encryption_wallet;

select * from all_encrypted_columns;

truncate table sh.enca;
select * from sh.enca;

impdp system/oracle@orcl directory=ORA_DIR dumpfile=enca.dmp tables=sh.enca TABLE_EXISTS_ACTION=replace

impdp system/oracle@orcl directory=ORA_DIR dumpfile=enca2.dmp tables=sh.enca TABLE_EXISTS_ACTION=replace ENCRYPTION_PWD_PROMPT = YES