Search notes:

Oracle: Init parameter DB_CREATE_FILE_DEST

If db_create_file_dest is not specified and create tablespace is executed without datafile clause, the following statement throws the error ORA-02199: missing DATAFILE/TEMPFILE clause. 
create tablespace ts_xyz;
Setting db_create_file_dest allows to use the same statement to create a tablespace: 
alter system set db_create_file_dest='/opt/oracle/oradata/FREE/tq84_pdb_01' scope = both;

Oracle ASM storage

Use Oracle ASM storage: 
alter system set db_create_file_dest = +DATA …;

See also

Oracle Managed File
Oracle recommends to set the value of db_create_file_dest to a different value than that of db_recovery_file_dest
init parameters

Index