Migrating BasicFiles to SecureFiles

It is recommended to migrate the BasicFile LOBs to SecureFile LOBs using the Online Table Redefinition method. The advantage of using the Online Table Redefinition method is that none of the objects have to be offline during the process. In addition, the performance of the redefinition process can be enhanced by enabling parallelism. The following example demonstrates the online redefinition process.

A TAB_BASICFILE table contains the DOC column that is a BasicFile CLOB column:

SELECT *
FROM tab_basicfile
/

        ID    DOC
---------- -------------
         1    Oracle 9i
         2    Oracle 10g
         3    Oracle 11g
         4    Oracle 12c

The following query checks the LOB behavior from the USER_LOBS dictionary view:

SELECT column_name,
       securefile
FROM user_LOBs
WHERE table_name='TAB_BASICFILE'
/

COLUMN_NAME SEC
----------- -----
DOC         NO

For redefinition, we will create a work-in-progress table with the same structure as the TAB_BASICFILE...