ORA-19502: write error on file "xxxxx", block number xxxx

时间:2024-04-03 21:18:16

报错SQL:
create tablespace smartbitbs datafile ‘/oradata/djdb/smartbi01.dbf’ size 30720m;

报错内容:
ERROR at line 1:
ORA-19502: write error on file “/oradata/djdb/smartbi01.dbf”, block number 1920640 (block size=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 1920640
Additional information: -1

报错原因:
从报错信息来看应该是写文件时遇到I/O错误,一般是磁盘空间不足导致。用df命令查看磁盘空间[[email protected] ignt]# df -h

解决办法:
要解决这个问题,可以减小数据文件的大小或为增加资源。

ORA-19502: write error on file "xxxxx", block number xxxx