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

Environment
10.2.0.4.0 Oracle Database on OEL 4 platform.

Problem
After I executed following expdp command, I immediately received following errors:

expdp system/******** tables=user1.table1 directory=expimp dumpfile=expdp_user1_table1.dmp logfile=expdp_user1_table1_`date +"%Y-%m-%d-%H%M"`.log parallel=4 tables=user1.table1


ORA-31693: Table data object "user1"."table1" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-39077: unable to subscribe agent ORA-39077: unable to subscribe agent KUPC$A_1_20110225

According to this link, I reattached to the job and modified my expdp command like following:
1 Check the expdp job name:

select job_name,state from dba_datapump_jobs;
JOB_NAME STATE
—————————— ——————————
SYS_EXPORT_TABLE_01 NOT RUNNING
2 Re-attach to the job and kill it
expdp system/xxx attach=SYS_EXPORT_TABLE_01

Export> kill_job

3 Redo export
expdp system/******** tables=user1.table1 directory=expimp dumpfile=expdp_user1_table1_%U.dmp logfile=expdp_user1_table1_`date +"%Y-%m-%d-%H%M"`.log parallel=4 tables=user1.table1



The above execution returned following new errors:

ORA-31693: Table data object "USER1"."TABLE1
ORA-29913: error in executing ODCIEXTTABLEOPEN callout .....
ORA-39077: unable to subscribe agent ORA-39077:........



Solution
Remove "parallel=4", it just works. I learned from my experience doing expdp/impdp in RAC environment, the "parallel" option is tricky, in 10g or 11g RAC, I had to add one more option of "cluster=N" in addition to "parallel=M", or it will fail.

References:

• Data pump export error ORA-39095 with FILESIZE and PARALLEL clauses
• Using Datapump Restart Capability for ORA-39095