Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert lob from basicfile to securefile

spur230Oct 17 2012 — edited Feb 11 2013
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2013
Added on Oct 17 2012
5 comments
3,122 views