Hi,

When at the end, I say


alter database datafile 'Filename at new location' online;

It gives me foll. error.

ORA-01113: file 40 needs media recovery
ORA-01110: data file 40: 'File name'

Then, from svrmgr> I recovered the datafile and then it allowed me to make it online.

So, what care should be taken so that I do not get above error in future?

I did not close the database while renaming the datafile. Is that OK?







[Edited by samdba on 07-02-2002 at 11:31 AM]