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

ORA-01114 ORA-03114

最新文章