Hi, thanks for the tips..actually I was trying to recreate a file that I don't have a backup for it. I read the Oracle B&R Guide and it suggested that we should use ..alter database create datafile... to recreate the file. Any ideas how to make this work?? Thank a whole bunch