ORA-01114: IO error writing block to file 201 (block # 763489) ORA-27072: I/O error Linux Error: 28: No space left on device

Event

Insert data into table

Error

ERROR at line 25:

ORA-01114: IO error writing block to file 201 (block # 763489)

ORA-27072: File I/O error

Linux-x86_64 Error: 28: No space left on device

Additional information: 4

Additional information: 763489

Additional information: -1

ORA-01114: IO error writing block to file 201 (block # 763489)

ORA-27072: File I/O error

Linux-x86_64 Error: 28: No space left on device

Additional information: 4

Additional information: 763489

Additional information: -1

Cause:

The device has run out of space. This could happen because disk space of files is not necessarily allocated at file creation time.

Action:

1) Remove unnecessary files to free up space.

2) Temp file system is full you need to add more space to temp or relocate the temp file system to another file system with more space :

select bytes/1024/1024/1024 size_GB,autoextensible,increment_by from dba_temp_files;

select owner,tablespace_name,segment_type,segment_name from dba_extents where file_id = 201 and block_id = 763489;

select file_name, tablespace_name, file_id, status from dba_data_files where file_id= 201

union all

select file_name, tablespace_name, file_id, status from dba_temp_files where file_id= 201;

--------------------

1)

CREATE TEMPORARY TABLESPACE temp2

TEMPFILE 'E:\APEXD1112\TEMP02.ORA' SIZE 500M REUSE

AUTOEXTEND ON NEXT 100M MAXSIZE unlimited

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100M;

2)

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

3)

DROP TABLESPACE temporary INCLUDING CONTENTS AND DATAFILES;

4)

cREATE TEMPORARY TABLESPACE temporary

TEMPFILE 'E:\APEXD1112\TEMP01.ORA' SIZE 500M REUSE

AUTOEXTEND ON NEXT 100M MAXSIZE unlimited

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100M;

5)

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temporary;

6)

DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

7)

SELECT tablespace_name, file_name, bytes

FROM dba_temp_files WHERE tablespace_name = 'temporary';

--------------------