DB_CREATE_FILE_DEST

DB_CREATE_FILE_DEST specifies the default location for Oracle-managed datafiles.

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
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 you specify a directory as the default location, then you must supply the full path of a file system directory and 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 AI Database Administrator’s Guide for more information on setting this parameter and on Oracle Managed Files