drop table sf4 purge;
drop table sf5 purge;
CREATE TABLE sf4 ( a CLOB)
LOB(a) STORE AS SECUREFILE (
COMPRESS HIGH
DEDUPLICATE
ENCRYPT USING 'AES128'
CACHE
LOGGING
tablespace USERTBS
);
CREATE TABLE sf5 ( a CLOB)
LOB(a) STORE AS SECUREFILE (
COMPRESS HIGH
CACHE
tablespace USERTBS
);
select * from user_lobs;