Re: datapump and deferred_segment_creation

Hi Ahmed,
> Is there any way to prevent oracle allocation 1M space for empty partitions while using datapump.

Take a look at the TRANSFORM parameter with the option for SEGMENT_CREATION:

https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/datapump-import-utility.html#GUID-64FB67BD-EB67-4F50-A4D2-5D34518E6BDB

Andy K

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Wednesday, May 12, 2021 10:42 AM, ahmed.fikri_at_t-online.de <ahmed.fikri_at_t-online.de> wrote:

> Hi all,
>
> When importing partitioned tables using the datapump, segments are allocated for empty table and index partitions (1MB each).
>
> The parameter deferred_segment_creation is set to TRUE.
>
> Is there any way to prevent oracle allocation 1M space for empty partitions while using datapump.
>
> Best regards
>
> Ahmed
>
> 

--
http://www.freelists.org/webpage/oracle-l