Expdp And Impdp Loses "Retention" Settings Of Lob Columns

(Doc ID 888951.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Standard Edition - Version: to
This problem can occur on any platform.


If a table with a LOB is created using RETENTION setting, expdp does not retain this setting and changes the flag to PCTVERSION. Also FREEPOOLS setting is lost.

Ran the following query before and after the expdp/impdp and you can clearly see the 'flag' setting change after the import of the LOB:
   SELECT b.owner, b.object_name, a.*
   FROM SYS.lob$ a, SYS.dba_objects b
   WHERE a.obj# = b.object_id AND b.object_name = 'LOB_DEMO'


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms