Implementing Oracle Managed Files (OMF)

Oracle 9i has the OMF feature that assists with the management and maintenance of database files.

One new initialization parameter is needed when you are using OMF with tablespaces in the database, DB_CREATE_FILE_DEST. You set this parameter to provide the default location for data files. The parameter, of course, can be overridden in a CREATE TABLESPACE statement. You can either set this parameter directly in the parameter file (initSID.ora), or it can be set dynamically through the use of the ALTER SYSTEM command:

					ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/mydatabases/mydb1';

After your database is configured to use OMF, the DATAFILE clause of the CREATE TABLESPACE command is no longer necessary. The ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial