Oracle-Managed Files (OMF)

Oracle-Managed Files (OMF)

Specify file operations in terms of database objects rather than file names.

Parameter	Description
DB_CREATE_FILE_DEST	Defines the location of the default file system directory for data files and temporary files
DB_CREATE_ONLINE_LOG_DEST_n	Defines the location for redo log files and control file creation
DB_RECOVERY_FILE_DEST	Default location for the fast recovery area

SQL> ALTER SYSTEM SET DB_CREATE_FILE__DEST '+DATA';
SQL> CREATE TABLESPACE tbs_1;