oracle 写入文件 出错,ora-01114:将块写入文件201时出现i/o错误解决

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.

如果是临时表空间的大小不够使用，将临时表空间重新创建即可。

创建步骤如下：

1.创建临时交换用的新的临时表空间TEMP2

CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE

'E:\ORACLE\ORADATA\SINO\TEMP02.DBF' SIZE 4096M REUSE AUTOEXTEND ON

NEXT 640K MAXSIZE UNLIMITED;

2.将数据的默认临时表空间设置TEMP2

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE

TEMP2;

3.删除原来的临时表空间TEMP

DROP TABLESPACE TEMP INCLUDING CONTENTS AND

DATAFILES;

4.重新创建原来的临时表空间TEMP

CREATE TEMPORARY TABLESPACE TEMP TEMPFILE

'E:\ORACLE\ORADATA\SINO\TEMP01.DBF' SIZE 4096M REUSE AUTOEXTEND ON

NEXT 640K MAXSIZE UNLIMITED;

5.将默认的临时表空间还原为原来的临时表空间TEMP

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE

TEMP;

6.删除临时用的临时表空间TEMP2

DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND

DATAFILES;

一切处理完后，数据库正常运转