conn test/test
show parameter secure
alter system set db_securefile='PREFERRED';
drop table bf1 purge;
create table bf1(
col1 number,
col2 clob)
lob(col2) store as basicfile
;
select * from user_lobs;
select TABLE_NAME, SECUREFILE from user_lobs;
conn test/test
show parameter secure
alter system set db_securefile='PREFERRED';
drop table bf1 purge;
create table bf1(
col1 number,
col2 clob)
lob(col2) store as basicfile
;
select * from user_lobs;
select TABLE_NAME, SECUREFILE from user_lobs;