OMF simplifies the creation of databases as Oracle does all OS operations and file naming. It has several advantages including:
* Automatic cleanup of the filesystem when database objects are dropped.
* Standardized naming of database files.
* Increased portability since file specifications are not needed.
* Simplified creation of test systems on differing operating systems.
* No unused files wasting disk space.
The location of database files is defined using the DB_CREATE_FILE_DEST parameter. If it is defined on its own all files are placed in the same location. If the DB_CREATE_ONLINE_LOG_DEST_n parameter is defined alternate locations and levels of multiplexing can be defined for Logfiles. These parameters are dymanic and can be changed using the ALTER SYSTEM statement.
* Automatic cleanup of the filesystem when database objects are dropped.
* Standardized naming of database files.
* Increased portability since file specifications are not needed.
* Simplified creation of test systems on differing operating systems.
* No unused files wasting disk space.
The location of database files is defined using the DB_CREATE_FILE_DEST parameter. If it is defined on its own all files are placed in the same location. If the DB_CREATE_ONLINE_LOG_DEST_n parameter is defined alternate locations and levels of multiplexing can be defined for Logfiles. These parameters are dymanic and can be changed using the ALTER SYSTEM statement.