Re: AW: datapump and deferred_segment_creation

Hello,

you can also check if the following parameter could be relevant in your case:

_partition_large_extents = 'FALSE'

You can check this note as well:

Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 11.2.0.2 or Later (Doc ID 1295484.1)

Regards
Dimitre

On 12/05/2021 17.02, ahmed.fikri_at_t-online.de wrote:
>
> Thanks Andy.
>
> I'll check if it is working for Table and Index partitions.
>
> However, I wonder the default value of the parameter
> |SEGMENT_CREATION| is set to Y, whereas deferred_segment_creation is
> set to true.
>
> Best regards
>
> Ahmed
>
> -----Original-Nachricht-----
>
> Betreff: Re: datapump and deferred_segment_creation
>
> Datum: 2021-05-12T16:52:29+0200
>
> Von: "Andy Klock" <andy_at_klockmail.com>
>
> An: "ahmed.fikri_at_t-online.de" <ahmed.fikri_at_t-online.de>
>
> 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
> <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