Database Administration (MOSC)

MOSC Banner

Set default attribute for lob partition table??

edited Jul 14, 2016 7:33AM in Database Administration (MOSC) 2 commentsAnswered

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




Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center