What alapps wrote will work for you - you need to add "drop" after offline.
alter database open;
select name, status from v$datafile; will show that your datafile is now offline.
+ Reply to Thread
Results 11 to 13 of 13
Thread: vert very urgent problem
Click Here to Expand Forum to Full Width