Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

system as opposed to a collection of datafiles. Since OMF uses the Oracle Disk
Manager file resize function, the tablespace files are initially created with the
default size of 100MB and grow as needed. Use the MAXSIZE attribute to limit
growth.
The following example shows the commands for creating an OMF database and
for creating the EMP_TABLE and EMP_INDEX tablespaces in their own locale.
Note: The directory must exist for OMF to work, so the SQL*Plus HOST command
is used to create the directories:
SQL> create database PROD;
The database is created.
SQL> HOST mkdir /PROD/EMP_TABLE;
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/PROD/EMP_TABLE';
The system is altered.
SQL> create tablespace EMP_TABLE DATAFILE AUTOEXTEND ON MAXSIZE \
500M;
A tablespace is created.
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = '/PROD/EMP_INDEX';
The system is altered.
SQL> create tablespace EMP_INDEX DATAFILE AUTOEXTEND ON MAXSIZE \
100M;
A tablespace is created.
Use the ls command to show the newly created database:
$ ls -lFR
total 638062
drwxr-xr-x 2 oracle10g dba 96 May 3 15:43 EMP_INDEX/
drwxr-xr-x 2 oracle10g dba 96 May 3 15:43 EMP_TABLE/
-rw-r--r-- 1 oracle10g dba 104858112 May 3 17:28 ora_1_BEhYgc0m.log
-rw-r--r-- 1 oracle10g dba 104858112 May 3 17:27 ora_2_BEhYu4NA.log
-rw-r--r-- 1 oracle10g dba 806912 May 3 15:43 ora_BEahlfUX.ctl
-rw-r--r-- 1 oracle10g dba 10489856 May 3 15:43 ora_sys_undo_BEajPSVq.dbf
-rw-r--r-- 1 oracle10g dba 104861696 May 3 15:4 ora_system_BEaiFE8v.dbf
Overview of database accelerators
About Oracle Disk Manager and Oracle Managed Files
62