Riyaj You need redo files, but not undo neither temp tablespaces. A few times I lose them and recreated successfully. You will need undo, if you abort your database, otherwise you don't need. (obviously I'm not talking in rac environment, I don't have idea about that) This is not a theory I tested it agains my will previously. :) -- //www.freelists.org/webpage/oracle-l