Oracle9i New Feature Series: Oracle Managed Files (OMF)

Oracle Managed Files (OMF) is introduced in Oracle9i. OMF lets the DBA not worry about file names and location once a parameter is defined in the database. This is good for non-production databases where you can afford to keep all your data files in one location or on LVM systems.

OMF is managed by the following parameters:

DB_CREATE_FILE_DEST Specifies the location of the data files. This parameter can be altered dynamically.

DB_CREATE_ONLINE_LOG_DEST_n Specifies the location of the redo log files. The n can from 1 through 5, meaning you can specify up to 5 locations for redo log files.


No need to specify the location, size or name of the data files when creating tablespaces.
Automatically removes files from the OS when tablespace or redo group is dropped.
Third party applications need not worry about OS specific file name conventions.

Im personally not a fan of OMF, but I use the INCLUDING CONTENTS AND DATAFILES clause of DROP TABLESPACE to remove the OS files when a tablespace is dropped. I like this feature.


Read more about OMF at OTN 9i daily feature March 20

Also, see Oracle documentation.

Search Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to The scripts, tips and articles appearing on cannot be reproduced elsewhere without the prior permission from the webmaster.