2.78 DB_CREATE_FILE_DEST
DB_CREATE_FILE_DEST
specifies the default location for Oracle-managed datafiles.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
There is no default value. |
Modifiable |
|
Modifiable in a PDB |
Yes |
Basic |
Yes |
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