conn test/test
show parameter secure
alter system set db_securefile='ALWAYS';
圧縮
create table sf1(
col1 number,
col2 clob)
lob(col2) store as securefile(
compress low
cache
nologging
);
select * from user_lobs;
重複除外
create table sf2(
col1 number,
col2 clob)
lob(col2) store as securefile(
deduplicate
cache
);
select * from user_lobs;
暗号化
select * from v$encryption_wallet;
create table sf3(
col1 number,
col2 clob)
lob(col2) store as securefile(
cache
encrypt using 'AES128'
);
select * from user_lobs;