October 27, 2009

ORA-27069 and ORA-01114

When creating a new object on a database (e.g. an index, a table) you get a set of ORA-27069 errors, each of them accompanied by ORA-01114. The description for these errors is:

ORA-27069 skgfdisp: attempt to do I/O beyond the range of the file
Cause: This is an internal error. The range of blocks being read or written is
outside the range of the file, additional information indicates the starting block
number, number of blocks in I/O, and the last valid block in the file.
Action: Check for a trace file and contact Oracle Support Services.

ORA-01114: IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.

How to work it out:

This can happen for a multitude or reasons: damaged storage, lack of storage space, etc. On Windows, namely Windows Server 2003 running a 32-bit file system, this can happen when one of the files in your tablespace reaches or crosses 4GB, 8GB, 12GB etc, so this may be the first thing to check.

You can use Oracle Enterprise Manager to check this: http://download.oracle.com/docs/html/B14399_01/rev_precon_db.htm#CACDJBBF

If, in fact, the problem is related to having a file with the characteristics above, you have plenty of options. For example, if you have an 8GB file in the USERS tablespace, you may have trouble adding data to that tablespace (which is the default for user tables, indexes, etc). To solve it, you can:
- set the file's maximum size below the size limit that started causing problems (e.g. 8GB)
- add more files to the tablespace where that file resides, so the tablespace can grow without creating very large files
- move indexes to a specific table space (ALTER INDEX REBUILD TABLESPACE ;)
- furthermore, you can create specific tablespaces for specific objects and move them there, which is way better than having every single object cramping up your default tablespace


All in all, the best way to solve this problem is to correctly manage your storage, tablespaces and files. Oracle ASM can help you with this. If you're running older versions, start here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm

38 comments:

EASY said...

正妹做愛影片無碼正妹上床做愛正妹上床做愛影片母子做愛文學水中做愛影片永平高中做愛洪爺做愛貼圖浪漫做愛浪漫床上做愛浴室做愛淫蕩娃做愛歐美愛做愛名模歐美同志做愛影片歐美做愛性愛短影片免費觀看未成年做愛做的事未成年做愛影片未滿18歲做愛影片本土美女做愛本土視訊做愛本土做愛自拍本土學生做愛照片桃色卡通做愛椅子做愛模特兒做愛歐美熟女做愛歐美線上做愛影片歐美做愛歐美做愛貼圖歐美做愛影片分享歐美做愛影片下載一夜情做愛上床.做愛上床做愛卡通版做愛歐美做愛影片男人做愛影片高中生做愛影片做愛-18免費女優電影做愛電影做愛前戲

元素 said...

good~ keep sharing with us, please....I will waiting your up date everyday!! Have a nice day........................................

春天來嚕 said...

very popular to u! ........................................

佳慧 said...

夫妻私密俱樂部素人自拍無碼女優自拍密錄館正妹無名相簿正妹裸照正妹桌面正妹桌布成人 影片星野亞希 h星野亞季星野亞西主題星野亞西樣式星野亞西桌布星野亞矢星野涼宇星野美由星野akari星空網路聊天室視訊 辣妹go2av免費影片航海王h短片分享go2av免費看影片go2av免費影片18 禁一葉情貼影入口18 成人girl5320免費影片18成人咆哮小老鼠視訊聊天免費成人片免費a片觀看真人野球拳免費聊天交友ut視訊080aa片直播台灣18網免費A片柔情聊天網一對多視訊聊天人妻貼圖

有南 said...

very popular to u! ........................................

RafaelLetso21555 said...

笑口常開~~天天開心........................................

RexTemples20144 said...

路過--你好嗎..很棒的BLOG.........................................

蘇pet0701em_halvorsen said...

I love readding, and thanks for your artical. ........................................

Stephany9991 said...

你所貫徹的形象,你喜愛它有多少百分比,你就幸福多少百分比........................................

許柏信 said...

I love readding, and thanks for your artical.........................................

名青 said...

一間沒有書的屋子,正如一個沒有窗子的房間。......................................................

韋于倫成 said...

我愛那些使自己的德行成為自己的目標或命定的人........................................

佳慧 said...

很喜歡你的文章~繼續加油唷^^. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

家谷 said...

說「吃虧就是便宜的人」,多半不是吃虧的人。 ............................................................

陳卓人 said...

It is no use crying over spilt milk.............................................................

暴枝盈 said...

你不能改變容貌~~但你可以展現笑容..................................................

溫淑芬 said...

工作,是愛的具體化~~~~努力吧!......................................................................

麗芬 said...

寂寞又無聊 看到你的BLOG 加油喔!!......................................................................

葉婷 said...

生存乃是不斷地在內心與靈魂交戰;寫作是坐著審判自己。....................................................................

亦妮亦妮 said...

閒來無聊逛逛blog~~跟您打聲招呼~~.................................................................

法邦法邦 said...

人生是故事的創造與遺忘。............................................................

雲亨雲亨雲亨 said...

安一估~你也安一估哦~............................................................

懿綺懿綺 said...

培養健全孩子最好的方法是父母先成為健全的人。............................................................

香昱信張君林 said...

相逢即是有緣~~留個言問候一聲,祝您平安順利............................................................

yol22andarodgersyolandarodge33rs said...

只有尋常才幹,但具有不尋常恆心的人,一切皆可獲取................................................

錢靜怡錢靜怡錢靜怡 said...

風平浪靜時,人人都可以當舵手.................................................................

青卉 said...

有空我一定會常來逛你的部落格!!!! ..................................................................

家榮家榮 said...

當最困難的時候,也就是離成功不遠的時候。..................................................

佳瑩佳瑩 said...

文章這麼好,怎麼可以不踩!............................................................

陳曉薇陳曉薇 said...

與人相處不妨多用眼睛說話,多用嘴巴思考. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

趙吳維倫彥廷 said...

人不能像動物一樣活著,而應該追求知識和美德............................................................

建茂恒霖 said...

開懷幸福的生活,是每個人的夢想~~希望大家都能夠實現!...............................................................

建邱勳 said...

Nothing comes from nothing.............................................................

倪平 said...

Everything comes if a man will only wait.............................................................

陳倩江陳倩江陳倩江 said...

人必須心懷希望,才會活的快樂,日子才過得充實,有意義,有朝氣,有信心。......................................................

智柏林婉林亞 said...

在你一無所有的時候 是誰在陪伴你 他便是你最重要的人......................................................................

江趙雲虹趙雲虹仁昆 said...

Necessity is the mother of invention..................................................................

48684 said...

好看耶~一定每天有空給你支持..................................................