From Oracle FAQ
Jump to: navigation, search

OMF (Oracle Manage Files) is a database feature, introduced in Oracle 9i, that simplifies tablespace creation. Using OMF, Oracle will automatically assign datafile names to tablespaces and automatically create and delete the required datafiles the operating-system level.


Some of the benefits of OMF are:

  • Easy file management - datafiles are automatically placed into the proper OS directory
  • Easy third-party application integration - third-party apps don’t have to be aware of OS-specific naming conventions
  • Fewer DBA errors - no risk of human error
  • Enforcement of the Optimal Flexible Architecture (OFA) standard
  • Default file sizes - OMF allows files to have standard, uniform sizes


Create a non-OMF tablepace:

CREATE TABLESPACE users ADD DATAFILE '/app/oradata/users01.dbf' SIZE 10M;

Create a OMF tablespace:

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #