5 Replies Latest reply on Feb 11, 2013 7:34 PM by spur230

    convert lob from basicfile to securefile

      I am usig Oracle Database 11g Enterprise Edition Release - Production.

      I was able to convert basicfile to securefile user alter table move command.

      However, Oracle documentation 11.2 says "Online redefinition is the only recommended method for migration of BasicFiles LOBs to SecureFiles LOBs."

      Please advise if there are any know issues for using " Alter table <tablename> move lob" to convert from basicfile to securefile.

      Why shouldnot we use simple alter table move lob statement as oppose to Online redefinition?
      ALTER TABLE scott.stat_table
          MOVE LOB(cl1) STORE AS  securefile (
              TABLESPACE users