Oracle Managed Files (OMF) | Oracle DBA Tutorial pdf

Oracle Managed Files (OMF)

Set following parameters in initialization file.
DB_CREATE_FILE_DEST – default location of new datafiles
DB_CREATE_ONLINE_LOG_DEST_n – specifies location for online log files and control files (max. 5 locations)
To create database using OMF, use
CREATE DATABASE MYDB DEFAULT TEMPORARY TABLESPACE TMP;