DB_create_file_dest initialization parameter settings

In oracle, this parameter is used to specify the default path for creating data files on the Oracle Database Server. In addition to data files, it is said that you can also create other default paths for files such as log files and control files, here, we only demonstrate the setting of the default path for this parameter to create a data file. Here we demonstrate the differences between the 10G and 11G parameters in the original default parameters. The setting methods are the same.
Before setting www.2cto.com, check that the value of db_create_file_dest is 10 Gb. The default value is 11 GB.
Www.2cto.com only displays the default database value. Before creating a database, you must determine the location where your database data files are stored. You can determine the location where your existing data files are stored, 10G is the same as 11G
Www.2cto.com and above are parameters before the data file is created. Now create the default data file path: run the following table space creation Script: create tablespace SYSTEM_MANAGED extent management local; an error will be reported when running the command in oracle 10G, prompting related clauses,
 
Because the default value is null, we need to run the alter system set DB_CREATE_FILE_DEST = ''statement to initialize and then run the script, here, I set the default path to the directory where the existing data file is located. Now we do not need to specify the path when creating the tablespace data file, for example, if you create a tablespace and a data file and create tablespace mytab directly, you can use the same method in 11G, but the db_create_file_dest parameter is different and the methods are the same, after you use alter system set DB_CREATE_FILE_DEST = ''to set the default path, run create tablespace SYSTEM_MANAGED extent management local; then SQL> select file #, status, name from v $ datafile;
FILE # STATUS NAME
----------------------------------------------------------------------
1 SYSTEM/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system
_ 8f85xnc8 _. dbf
2 ONLINE/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux
_ 8f85xng5 _. dbf
3 ONLINE/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotb
S1_8f85xngn _. dbf
4 ONLINE/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users _
8f85xnhk _. dbf
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_create_file_dest string/u01/app/oracle/oradata
SQL> show user
USER is "SYS"
Set to save to the existing path:
SQL> alter system set DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/ORCL/datafile /';
System altered.
SQL> create tablespace SYSTEM_MANAGED extent management local;
Tablespace created.
View:
SQL> create tablespace data;
Tablespace created.
SQL> select name from v $ datafile;
NAME
--------------------------------------------------
/U01/app/oracle/oradata/ORCL/datafile/o1_mf_system
_ 8f85xnc8 _. dbf
/U01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux
_ 8f85xng5 _. dbf
/U01/app/oracle/oradata/ORCL/datafile/o1_mf_undotb
S1_8f85xngn _. dbf
/U01/app/oracle/oradata/ORCL/datafile/o1_mf_users _
8f85xnhk _. dbf
/U01/app/oracle/oradata/ORCL/datafile/ORCL/datafil
E/o1_mf_system_m_8hhgltcb _. dbf
/U01/app/oracle/oradata/ORCL/datafile/ORCL/datafil
E/o1_mf_data_8hhgv6k5 _. dbf
6 rows selected.

SQL> show parameter DB_CREATE_FILE_DEST;


NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_create_file_dest string/u01/app/oracle/oradata/ORCL/datafile/