ITPub博客

首页 > 数据库 > Oracle > ORA-01114 ORA-03114

ORA-01114 ORA-03114

原创 Oracle 作者:playwawa 时间:2006-05-23 17:35:25 0 删除 编辑

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

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

[@more@]
Subject: ORA-01114 and ORA-27072 During Migration
Doc ID: Note:152641.1Type: PROBLEM
Last Revision Date: 05-JUN-2002Status: 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    105
  • 访问量
    1173704