OMF
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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 | # |
