ORA-39095: Dump file space has been exhausted

For datapumpt export, we use %U substitution variable when we intend to create multiple export dump files through parallel export or dump file size restriction impose using parameter filesize. In this case, maximum number of dumpfiles that could get created are 99 (from 01 to 99). Eventually your export would fail with ORA-39095 if export data size requires more dump files to be created but 99dump files limit has already reached. Following is the parameter file that I used to export and the error I received during 29T size of data export.

Parameter file export_schema_2.par directory=EXP_DIR dumpfile=SCHEMAS_2_%L.dmp logfile=SCHEMAS_2.log parallel=40 compression=all full=y exclude=schema:"in('SCHEMA1,SCHEMA2,SCHEMA3')" filesize=80g cluster=n   Error message returned ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes Job "SYS"."SYS_EXPORT_FULL_02" stopped due to fatal error at Sun Jun 8 00:46:06 2025 elapsed 0 13:15:01

To avoid this error, either you should look into your dumpfiles sizing using filesize parameter so that number of files remains within limit by increasing size of export dump files. Alternatively, use %L (or %l) substitution variable in dumpfiles name instead of %U (or %u). This will continue generating dumpfiles while numbering them beyond 99