ORA-01114 ORA-03114

最新推荐文章于 2024-12-20 15:44:41 发布

转载最新推荐文章于 2024-12-20 15:44:41 发布 · 119 阅读

本文记录了在从Oracle7迁移到Oracle8.1的过程中遇到的ORA-01114及ORA-27072错误。错误原因是目标系统TEMP表空间空间不足及文件系统设置不当导致数据文件写入失败。

很久沒碰oracle了,連metalink登陸方式變了都不知道,唉.....

在做一個系統的時候碰到一個小錯誤,google不到好的結果就去,metalink了一把後連到DB看了一下的確是TEMP tablespace空間不夠了,暈,增大後繼續做事情了,具體見下

[@more@]

Subject:	ORA-01114 and ORA-27072 During Migration
	Doc ID:	Note:152641.1	Type:	PROBLEM
	Last Revision Date:	05-JUN-2002	Status:	PUBLISHED

fact: Oracle Server - Enterprise Edition 8.1
fact: HP 9000 Series HP-UX
symptom: Database Migration Fails
symptom: Can not write data into datafile
symptom: ORA-01114: IO error writing block to file %s (block # %s)
symptom: ORA-27072: skgfdisp: I/O error
symptom: HP-UX Error: 22: Invalid argument
change: Migrated from Oracle 7
cause: HP-UX does not check the size of creating files.

fix: On OS level: - check permission of the datafile - compare size of the datafile and size of filesystem (HP-UX Error) - make sure that the filesystem has enough space

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

转载于:http://blog.itpub.net/202861/viewspace-837339/