expdp ORA-39095

1.1. ORA-39095: Dump file space has been exhausted

1.1.1. 现象：

[oraprod@ebsdb1 dump]$ expdp system/***** DIRECTORY=dump_dir TABLESPACES=CUX_SMALL dumpfile=cux_small.dmp parallel=4 job_name=expdpjob3 logfile=expdp1.log;

Export: Release 11.2.0.3.0 - Production on Tue Jul 15 11:35:16 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Starting "SYSTEM"."EXPDPJOB3": system/******** DIRECTORY=dump_dir TABLESPACES=CUX_SMALL dumpfile=cux_small.dmp parallel=4 job_name=expdpjob3 logfile=expdp1.log

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 3.952 GB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

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

1.1.2. 解决方法

减少并行度PARALLEL=4 改为PARALLEL=2即可

http://blog.itpub.net/12778571/viewspace-692482

http://www.itpub.net/thread-1061074-1-1.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14710393/viewspace-1219063/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14710393/viewspace-1219063/