Oracle 10g Administration 1

Oracle Managed Files (OMF)

DB_CREATE_FILE_DEST
Defines the location of the default file system directory for data files and temporary files
DB_CREATE_ONLINE_LOG_DEST_n
Defines the location for redo log files and control file creation
DB_RECOVERY_FILE_DEST
Defines the location for RMAN backups

SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/u01/oradata';
SQL> CREATE TABLESPACE tbs_1;