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.

Note:

1. This parameter was introduced in Oracle9i.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘DB_CREATE_FILE_DEST’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_create_file_dest		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	default database location

Oracle initializatoin parameters