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 string /u01/app/oracle/oradata DB_CREATE_ONLINE_LOG_DEST_n Defines the locations of the redo log files and control files creations. DB_RECOVERY_FILE_DEST Default location for the fast recovery area. SQL> s