-
Unable to drop table.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|