Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafile problem on 8.0.4 (windows NT)
Hi
Itīs no problem. Just set the datafile offline immediate:
alter database datafile 'filename' offline immediate;
after that you can open your database normal. If your database is in archivelog restore the datafile and recover it.
now you can set the datafile online again.
Bye
Mario
![]() |
![]() |