Originally posted by ashley75
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
First, you have to create the undo tablespace. Oracle will create the undo segments. If the datafile(s) is OMF, then you can rename but with a lot of restrictions. You know for one that a file is considered OMF if its base file name had:
- an "ora_" prefix
- and a ".dbf", ".tmp", ".log" or ".ctl" extension
What would you like to rename? From what to what?