Skip to Main Content

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 'parallel' not functioning properly !

shipon_97May 24 2014 — edited May 26 2014

I am using our Production server with  oracle 10g on Linux Enterprise version 5 with DELL server . Here when I make any expdp backup with parallel option then I got the below error :

---

Processing object type SCHEMA_EXPORT/JOB

Processing object type SCHEMA_EXPORT/REFRESH_GROUP

. . exported "ULTIMUS"."COR_GLMASTER_HIST"               40.14 GB 153039611 rows

. . exported "ULTIMUS"."TFN_IMP_LC_HIST"                 17.75 GB 5355726 rows

ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 20:19:54

---

I search the metalink and found a note "Doc ID 559692.1" for solution . Here the document says to split the backup dumpfile equal to  parallel value.

Now, On another environment with oracle10g setup including Enterprise Linux 5.0 , I cannot found this types of error . Interesting matter is , that backup data is the redundant copy of the production data . There I use single dumpfile with parallel option . Both server we have 8 cpu .

My question is , is this problem related with any operating system configuration issue ? Does any os parameter depends on this parallel keyword ?

Waiting for expert opinion .... ...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2014
Added on May 24 2014
4 comments
2,243 views