Re: Transportable Tablespaces and Deferred segment creation "bug"

From: Yong Huang <>
Date: Tue, 27 Nov 2012 08:38:32 -0800 (PST)
Message-ID: <>

> I don't buy the space saving thing (there might be dictionary performance

I'm with Niall here. Deferred segment creation is a feature that brings very little benefit (negligible space saving in ratio, not in absolute amount), with unexpected side effects. I was about to set deferred_segment_creation to false on all our 11g databases because some of our traditional export dumps are found missing tables due to this feature. Then I found

Original Export Raises EXP-11 Table Does Not Exist or Table is Ignored [ID 960216.1]

and realize it's only a problem in, and most of our databases are or will soon be, so I didn't bother. In the meantime, we changed those exp jobs to expdp to avoid this problem in, and keep in mind not to use exp ad-hoc.

I didn't know this was still a problem in case of transportable tablespace export, in version higher than

Yong Huang

Received on Tue Nov 27 2012 - 17:38:32 CET

Original text of this message