Expdp And Impdp Loses "Retention" Settings Of Lob Columns
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Standard Edition - Version: 10.2.0.1 to 10.2.0.4
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