免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2676 | 回复: 1

expdp时报错? [复制链接]

论坛徽章:
0
发表于 2008-07-01 11:42 |显示全部楼层
OS:AIX5.3
DB:ORA10GR2

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_43":  system/******** schemas=symbols directory=MYDIR dumpfile=UDBPROD_SYMBOLS_EXPDP_2008070104
03.dmp logfile=UDBPROD_SYMBOLS_EXPDP_200807010403.log parallel=10
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 52.44 GB

. . exported "SYMBOLS"."GL_POST":"PMAXVALUE"             3.450 GB 16575355 rows
. . exported "SYMBOLS"."FM_AUDIT_LOG_REP"                10.46 KB       8 rows
ORA-31693: Table data object "SYMBOLS"."RB_TRAN_HIST":"PMAXVALUE"."SMAXVALUE" failed to load/unload and is being skipped due to error:
ORA-19502: write error on file "/oradata_d2/udbprod/DBBAK/dumpfile/UDBPROD_SYMBOLS_EXPDP_200807010403.dmp", blockno 8110777 (blocksize=4096)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 262144

该目录下还有75G,何以会把“空间不足”?

另:数据库db_block_size=8k,错误信息中的“blockno 8110777 (blocksize=4096)”从何而来啊?

请各位大虾赐教,谢谢!

论坛徽章:
1
丑牛
日期:2014-08-07 17:07:05
发表于 2008-07-01 14:13 |显示全部楼层
提示: 作者被禁止或删除 内容自动屏蔽
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP