oracle提示39095,案例:Oracle数据泵expdp导出时报错ORA-39095: Dump file space has

天萃荷净

Oracle数据库数据泵expdp导出时报错ora 39095，分析原因为PARALLEL和DUMPFILE关系导致

今天有朋友在说PARALLEL设置为n(大于1)，DUMPFILE为一个文件(不包含%U),会出现什么样的情况。下面通过实验来说明这个问题

1.当并发数比较大时(这里实验使用4),expdp会报ORA-39095错误

[oracle@node1 tmp]$ expdp chf/xifenfei DUMPFILE=xifenfei.dmp TABLES=t1 PARALLEL=4

Export: Release 11.2.0.3.0 - Production on Wed Mar 7 20:48:52 2012

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, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

Starting "CHF"."SYS_EXPORT_TABLE_01": chf/******** DUMPFILE=xifenfei.dmp TABLES=t1 PARALLEL=4

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE