Search This Blog

Thursday, April 10, 2014

Exhausted by Data pump ORA-39095: Dump file space has been exhausted

Have you run into this issue before and thought the disk was the cause?

Checking the space free and used reveals that there is adequate space.

Did you set the parameter filesize in your parameter file?

If you did, please check the number of dump files created.

ls -l *.dmp |wc -l

Is the number returned 99?

If so, you have hit the limit of the maximum number of files data pump can allocate for an export.

There are two possible solutions:


  1. Increase the filesize parameter ensuring you have calculated the space needed for the export, so that it can fit into 99 files
  2. Remove the filesize parameter and let Oracle decide how big to make the files. This is dependent on the OS limits and the number of threads or workers specified.




No comments:

Post a Comment