You might get one more problem while doing any transaction- this is because ( I assume) the undo segments defined are refering to the lost file. I created another undo tablespace and changed the parameter undo_tablespace to the new one and problem resolved.