Andrew Fraser DBA

Move LOB Partitions

SELECT 'ALTER TABLE ' || LOWER ( table_owner || '.' || table_name ) || ' MOVE PARTITION ' || partition_name
       || ' LOB ( ' || LOWER ( column_name ) || ') STORE AS SECUREFILE ( TABLESPACE data1 ) ;' AS sqlCmd
     , tablespace_name
     , partition_position
     , securefile
  FROM dba_lob_partitions 
 WHERE table_owner = 'MYOWNER' 
   AND table_name = 'MYTABLE'
   AND securefile = 'YES'
 ORDER BY table_owner , table_name , column_name , partition_position
;