DB_CREATE_FILE_DEST
Property | Description |
---|---|
Parameter type | String |
Syntax | DB_CREATE_FILE_DEST = directory | disk group |
Default value | There is no default value. |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Basic | Yes |
DB_CREATE_FILE_DEST
specifies the default location for Oracle-managed datafiles. This location is also used as the default location for Oracle-managed control files and online redo logs if none of the DB_CREATE_ONLINE_LOG_DEST_
n
initialization parameters are specified.
If a file system directory is specified as the default location, then the directory must already exist; Oracle does not create it. The directory must have appropriate permissions that allow Oracle to create files in it. Oracle generates unique names for the files, and a file thus created is an Oracle-managed file.
这个参数用于指定Oracle数据库服务器创建以下文件的缺省路径:
■ Datafiles
■ Tempfiles
■ Redo log files
■ Control files
■ Block change tracking files
指定这个参数后,就不需要在创建表空间时指定具体的datafile的文件路径和名称了。
例如:
在设置这个路径参数之前:
show parameter DB_CREATE_FILE_DEST;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string
运行如下创建表空间脚本:
create tablespace SYSTEM_MANAGED
extent management local;
系统会报错:
第 2 行出现错误:
ORA-02199: 缺失 DATAFILE/TEMPFILE 子句
设置这个参数:
alter system set DB_CREATE_FILE_DEST = 'D:/oradata/NOC';
然后再运行上面的创建表空间脚本,就会成功。
--本篇文章转自:http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams050.htm#REFRN10034,
http://blog.csdn.net/swordmanwk/article/details/6232445