-
Hi All,
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.
Louis.
-
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.
