OMF

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.

Benefits

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

Examples

Create a non-OMF tablepace:

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

Create a OMF tablespace:

CREATE TABLESPACE users;

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	#