Thanks Tim,

I am bit clearer now with this new function, one last question, So if you set UNDO_MANAGEMENT=AUTO, Oracle will automatically create the UNDO segment with its own naming convention??? Its naming convention is not nice at all, is there a way for you to change it????

Thanks