创建表时出错，请大家看看

dongdongwx

ERROR at line 7:
ORA-01114: IO error writing block to file 13 (block # 40913)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 9: Bad file number
Additional information: 40913
ORA-01114: IO error writing block to file 13 (block # 40913)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 9: Bad file number
Additional information: 40913
ORA-01114: IO error writing block to file 13 (block # 40913)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 9: Bad file number
Additional information: 40913

dongdongwx

我没有找到你要说的亚

yikaikai

什么系统， 见表语句， 估计是空间不够， 或者你创建的表空间太大

dongdongwx

在hp-unix11上，语句如下

create table one_per as
select rownum as name_id,name from one_per_20010901;

CCBZZP

剛才誰刪除了我的一個帖子啊!!!???

yikaikai

你那个广告， itpub的联接顶上有

dongdongwx

CCBZZP
我没有找到你要说的亚
在www.itpub.net
能否详细些？

dongdongwx

up

gototop

错误信息说得很清楚了啊：
dragon1>; oerr ora 1114
01114, 00000, "IO error writing block to file %s (block # %s)"
// *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.

dongdongwx

奥
我试试