This content has been marked as final. Show 2 replies
Please refer this http://docs.oracle.com/cd/B13789_01/server.101/b10739/omf.htm
Your questions are answered in the above document. I have most of my databases on OMF and I leave it to Oracle on assigning the names.
ninteckIf you feel that your questions have been answered, then please consider closing your questions by providing appropriate points and marking them as answered. Please keep the forum clean !
Status Level: Newbie (5)
Registered: Sep 12, 2005
Total Posts: 25
Total Questions: 5 (4 unresolved)
1 person found this helpful
Even if you explicitly specify the name for a file, ASM will actually creates the filename with OMF standard and explicit name will be just alias for that file.
Wanted to get opinions on what dbas prefer: let asm handle naming or explicitly name your datafiles? +DATA/orcl/datafile/products.133.84672930 or +DATA/orcl/datafile/products01.dbf Reasons? Ease of maintenance, backup/recover, etc?
So no need specify the name.