OMF Tablespace in 19c database
Oracle Managed Files (OMF) handles file creation and deletion directly at the operating system level. Sample we only need to specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's data file with the DATAFILE clause. This feature works well with a logical volume manager (LVM). Below installation parameters are must enable the OMF. DB_CREATE_FILE_DEST Defines the locations of the default file system directory for the datafiles and temporary files. SQL> show parameter DB_CREATE_FILE_DEST NAME TYPE VALUE ------------------------------------------------------------------------------- db_create_file_dest ...