I had some unwanted tablespaces . I dropped all of them except one. I deleted all the datafiles aasociated with these tablespaces including the datafile of the tablespace which I forgot to drop;
I did'nt notice this , but when I restarted the database , it gives the error
ORA-01110: data file 24: '/oradata/oradata/MAPS/MAP_RBS_GEN_DF01.DBF'
ORA-01115: IO error reading block from file 24 (block # 1)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
I tried through server manager but , not able to make the tablespace offline without opening the database.
Can anybody suggest me which way can I open the database.
Thanks in Advance.
In this case try to drop datafile from database:
ALTER DATABASE DATAFILE '/oradata/oradata/MAPS/MAP_RBS_GEN_DF01.DBF' OFFLINE DROP;
After that try to open database,
alter tablespace offline immediate;
drop tablespace 'ts';
In which mode r u running ur database.If its in noarchive log mode,use alter database datafile 'filename' offline drop;
else if ur database is running in archive log mode.
start ur database in mount phase, take the datafile offline.And then take the tablespace offline and then drop it.
Click Here to Expand Forum to Full Width