Bruno, Thank you. I ran with %L and it created 143 files and it complete.

Yes, I did think about breaking it down by date but this option may be cumbersome.

Hello Jack,

simply replace %U by %L !

Best regards,

Bruno Vroman

Hello Jack,

and other ideas (%L is perfect, these are just other ways of working):

-a- you might use COMPRESSION (beware that this implies licensing)

-b- you might have multiple expdp sessions using the QUERY clause for various non-overlapping parts of the data, for example if we have a column "mydate NOT NULL", you might have a session "WHERE mydate < DATE '2020-01-01'", another one "WHERE mydate >= DATE '2020-01-01' AND mydate < DATE '2023-01-01'" and a last one with "WHERE mydate >= DATE '2023-01-01'" (just an example, you see the idea). (/!\ note that this way might cause some headaches if you have to import all the data in another target; I mention if because it might be useful especially if you can forsee an impdp of a subset of the original data)

(-c- about impdp of a subset, we can also mention the "SAMPLE" clause of expdp…)

Best regards,

Bruno