Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump is approaching limit of 99 files with %U.dmp name

DCinDUBFeb 25 2020 — edited Mar 2 2020

Hi MOSC, We have a 11.2.0.4 release on our ODA X5-2.

We have datapump job in which it is producing close to the limit of (99) dmp files using %U.dmp in the par file (below) ;

SCHEMAS=TEST16652

FILESIZE=2048M

DUMPFILE=SCHEMA_DMP:EXPDP_TEST16652_%U.DMP

LOGFILE=SCHEMA_LOG:EXPDP_TEST16652.LOG

FLASHBACK_TIME=SYSTIMESTAMP

PARALLEL=6

Currently the dmp file set has 87 files and is around 180 GB total in size.

Q1) To get around the 99 file limit, do we simply increase the FILESIZE from 2GB to 4GB, thus essentially cutting in half the the number of files used in the job?

Q2) If above is not the answer what shall we do to avoid 99 file limit ?

Thank you for your time.

Best Regards,
Donald

This post has been answered by Daniel Overby Hansen-Oracle on Feb 25 2020

Jump to Answer

Added on Feb 25 2020

#database-key-features, #export-import-sql-loader-external-tables

4 comments

5,092 views