Set default attribute for lob partition table??
Hi
I have problem to change the default attribute for lobs so that new partitions get created with securefile instead of basicfile. Running Oracle 11.2.0.4.
alter session set db_securefile = 'PERMITTED';
Create partitioned table with a lob/clob in
create table test_lob (pk_id number ,requestlob clob ) PARTITION BY RANGE (pk_id) ( PARTITION id VALUES LESS THAN (100));
Add a partiton that also will not use securefile
alter table test_lob add partition values less than(200);
select column_name, lob_name, partition_name, lob_partition_name, tablespace_name, securefile from user_lob_partitions where table_name = 'TEST_LOB';
COLUMN_NAME LOB_NAME PARTITION_NAME LOB_PARTITION_NAME TABLESPACE_NAME SECUREFILE --------------- ------------------------------ ------------------------------ ------------------------------ -------------------- ---------- REQUESTLOB SYS_LOB0009526482C00002$$ FIRSTPART SYS_LOB_P1516051 USERS NO REQUESTLOB SYS_LOB0009526482C00002$$ SYS_P1516053 SYS_LOB_P1516054 USERS NO