DB_CREATE_FILE_DEST usage in Oracle Managed Datafiles
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;
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;
0