Deferred segment creation and datapump
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Feb 2013 11:41:52 -0600
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.'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
