Originally posted by ashley75
1. If you have OMF, Oracle will manage on of your file(control file, redo log file, and datafile), what about Rollback???
Could you please reformulate the question?

2. Oracle will manage undo tablespace automatically IF you set UNDO_MANAGEMENT=AUTO, right??? Another word, OMF is seperate function with UNDO_MANAGEMENT, right???
Right.

On my database now, I don't use OMF but I set UNDO_MANAGEMENT=AUTO, is it ok ???
It is OK.

what do you use for your production database, how every other DBA use for their database???
Use what?


The bottom line I really like to undertsand is OMF and UNDO_MANAGEMENT si two seperate function in 9i right???
They are separate things, yes.