Deferred segment creation and datapump

From: Andrew Kerber <>
Date: Fri, 8 Feb 2013 11:41:52 -0600
Message-ID: <>

I recently ran into a problem with datapump where empty tables where empty tables were not being exported. We have a piece of commercial software that has a lot of tables, many of which we do no use. However, without those tables, stored procedures and triggers do not compile properly. Some research showed that the problem was the deferred_segment_creation
'feature' in 11gR2. So, I went ahead and turned that off (alter system set
deferred_segment_creation=false scope=both), and allocated extents on the applicable tables. So, my question is, does datapump have a parameter that can be set to get tables with no extents allocated? Non-critical obviously, but I would be interested to know what the setting is if it exists.
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'
Received on Fri Feb 08 2013 - 18:41:52 CET

Original text of this message