5 Replies Latest reply: Feb 11, 2013 1:34 PM by spur230 RSS

    convert lob from basicfile to securefile

    spur230
      I am usig Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 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
          );
      Thanks.