Property Description
Parameter type String
Syntax DB_CREATE_FILE_DEST = directory | disk group
Default value There is no default value.
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.

See Also:

Oracle Database Administrator's Guide for more information on setting this parameter and on Oracle-managed files