Archive for 九月 6th, 2010

ora-39095

星期一, 九月 6th, 2010

今天在导出数据文件的时候,倒着倒着就报错了
ORA-39095:Dump file space has been exhausted: Unable to allocate string bytes
Cause: The Export job ran out of dump file space before the job was completed.
Action: Reattach to the job and add additional dump files to the job restarting the job.

从报错的字面意思,一开始以为系统空间问题,但是空闲的空间还是很多的,根据提示增加了个dumpfile但是还是报错,后来查了下METALINK,可能是我的PARALLEL太高了。我从8改为4就好了。或者也可以通过增加DUMPFILE,也能解决问题。 dumpfile=hisdeliverxU%就OK。记录下