{SecureFiles}BasicFilesを使用したテーブルを作成

 

https://docs.oracle.com/cd/F19136_01/adlob/using-oracle-LOBs-storage.html#GUID-AD240DE1-392F-41EC-864D-2D892CF7D45A

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;