ORA-01114: IO error writing block to file 201
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.
查看临时文件
select FILE#,TS#,NAME,STATUS,ENABLED from v$tempfile;
查看临时文件是不是自动扩展
select FILE_NAME,FILE_ID,TABLESPACE_NAME,AUTOEXTENSIBLE ,STATUS from dba_temp_files;
alter database tempfile '..../temp.dbf' autoextend off
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.
查看临时文件
select FILE#,TS#,NAME,STATUS,ENABLED from v$tempfile;
查看临时文件是不是自动扩展
select FILE_NAME,FILE_ID,TABLESPACE_NAME,AUTOEXTENSIBLE ,STATUS from dba_temp_files;
alter database tempfile '..../temp.dbf' autoextend off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11976525/viewspace-702029/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 一个抽取outlook邮件信息的VBA script
- ORA-00600: [kkocxj : pjpCtx]
- ORA-00600: : [rworupo.1], [30], [24]
- ORA-00600: internal error code, arguments: [kxfpg1sg:INV],
- 一次因临时表空间问题而导致的RAC节点failover
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ASM
- ORA-02396: exceeded maximum idle time, please connect again .
- oracle 内存分配之最细粒度granule
- ORA-04031: unable to allocate 3896 bytes of shared memory
