Database Software

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!

Datapump Import LOB Securefile Compression

MichalSJun 14 2016 — edited Jun 16 2016

Good evening,

I have a question regarding LOB compression and data pump. Here is my scenario:

I have a partitioned table with a LOB (securefile). If I truncate the partition, compress(medium) the LOB, and then re-import the data, should I expect the LOB to be compressed? Or will I need to recompress the LOB after importing the data?

Thank you!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2016

Added on Jun 14 2016

#database-key-features, #export-import-sql-loader-external-tables

1 comment

925 views