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!

Best way to remove securefile-compression from LOB

3407237May 22 2017 — edited May 23 2017

I am requested to remove compression and securefile definition from a LOB column in one table.

Current definition is:

LOB ("FILE_CONTENT") STORE AS SECUREFILE (

TABLESPACE ... COMPRESS HIGH KEEP_DUPLICATES

My question is if there is a procedure to "alter" that table or Should I create a new table and move data (may be with exp/impdp or insert into select)?

Thanks for the help

Regards

Jorge

This post has been answered by Andy Klock on May 22 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2017

Added on May 22 2017

#general-database-discussions

2 comments

795 views