Database Administration (MOSC)

MOSC Banner

DB_CREATE_FILE_DEST usage in Oracle Managed Datafiles

edited Apr 4, 2013 6:29AM in Database Administration (MOSC) 4 commentsAnswered
 Hello all, To enable the Oracle Managed Datafiles, we need to set a value (path) to the parameter DB_CREATE_FILE_DEST. 

My question: Are all of the data files created in this directory managed by Oracle?
For example:

SQL> ALTER SESSION SET DB_CREATE_FILE_DEST='C:\temp\ora\OMF';
Session altered.

SQL> show parameters db_create_file_dest;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string      C:\temp\ora\OMF


Now I create 3 tablespaces: KIMTS1, KIMTS2 and KIMTS3

[1]
CREATE TABLESPACE kimTS1 DATAFILE AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
[2]
CREATE TABLESPACE kimTS2 DATAFILE 'C:\temp\ora\OMF\kimTS2.dbf' SIZE 1M AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center