Dear Friends,

I have the following issue in my database. This is my development server. I need to drop one table, it is giving the following error.

drop table data_to_rom;

ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 1 (block # 11024)
ORA-01110: data file 1: '/oradata/oradata/system01.dbf'
ORA-27091: skgfqio: unable to queue I/O
SVR4 Error: 5: I/O error
Additional information: 11023

This table is in a tablespace called sds_temp_ts which is having 3 datafiles. I am able to see these datafiles from dba_data_files with status as AVAILABLE.
In the V$DATAFILE, the columns status is 'OFFLINE'.
In the v$datafile_header, the column error is 'OFFLINE NORMAL'.
But these files are not in OS. I think they were accidentely removed from OS. When I have tried to drop these files from the database, it is giving the message sucessfuly dropped. But the status in the above v$ views retains the same.

When I tried to drop the tablespace, I am getting the same error

ORA-00604: error occurred at recursive SQL level 1
ORA-01115: IO error reading block from file 1 (block # 11024)
ORA-01110: data file 1: '/oradata/oradata/system01.dbf'
ORA-27091: skgfqio: unable to queue I/O
SVR4 Error: 5: I/O error
Additional information: 11023

Even when I tried to drop the user, I am getting the same error.
Now my requirement is I need to drop this table, if it not possible, I would like to drop the datafiles, even if this is not possible I would like to drop the tablespace and at last I am ready to drop the schema also.

Please let me know how to proceed on this.