Oracle 8im is in NO Archive Mode. I made one datafile of a tablespace offline drop and the physical file also dropped.
But Still Oracle looking for that datafile!!!! Why??
How can I make it staus unavailable??? I really need to get rid of it