ORA-01114 ORA-03114

很久沒碰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/