Issue while creating an index

[mayank86]

Hi

While creating an index on SAP system with oracle we are getting the below error

> ORA-01114: IO error writing block to file (block #

> )#ORA-01114: IO error writing block to file 255 (block #

> 161792)#ORA-27085: Message 27085 not found; product=RDBMS;

> facility=ORA#Additional information: 106496#Additional

We checked the table spaces- no issues

The field and the block doesn't exists.

Pl help.

[mayank86 · Accepted solution]

Hi

The issue has been resolved after creating another temp tablespace and activating it.

The issue is due to the temp file #. This happens as temp tablespace tries to find out the next file # in the default sapdata folder. And if that particular sapdata directory is full then this error occurs. No matter even if you increase the temp tablespace with another sapdata.

-- the query will always return 0 value as the file # and the block doesn't exists on the system.

Thanks all for the help.

Regards,

Mayank

[former_member188883]

Hi Mayank,

Please execute below SQL to identify the object having problem. Based on object identification next steps can be planned.

select segment_name, partition_name, segment_type, block_id, blocks

from dba_extents

where (161792 between block_id and (block_id + blocks - 1))

and file_id = 255 and rownum < 2;

Hope this helps

Regards,

Deepak Kori

[ashish_vikas]

> )#ORA-01114: IO error writing block to file 255 (block #

please check which data file is with id 255 ?

you can use below query for this :

SQL> select file_name, tablespace_name, file_id, status from dba_data_files where file_id= 255;

If this is a temp data file, you can work with resolution of below SAP Note.

1890999 - ORA-01114 ORA-27072 occurs for Tempfiles

best regards

ashish