VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 5, Using VERITAS Extension for Oracle Disk Manager
Prerelease 8 September 2005, 8:54am Oracle Disk Manager and Oracle Managed Files
129
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 oracle9i dba 96 May 3 15:43 EMP_INDEX/
drwxr-xr-x 2 oracle9i dba 96 May 3 15:43 EMP_TABLE/
-rw-r--r-- 1 oracle9i dba 104858112 May 3 17:28 ora_1_BEhYgc0m.log
-rw-r--r-- 1 oracle9i dba 104858112 May 3 17:27 ora_2_BEhYu4NA.log
-rw-r--r-- 1 oracle9i dba 806912 May 3 15:43 ora_BEahlfUX.ctl
-rw-r--r-- 1 oracle9i dba 10489856 May 3 15:43
ora_sys_undo_BEajPSVq.dbf
-rw-r--r-- 1 oracle9i dba 104861696 May 3 15:4
ora_system_BEaiFE8v.dbf
-rw-r--r-- 1 oracle9i dba 186 May 3 15:03 PROD.ora
./EMP_INDEX:
total 204808
-rw-r--r-- 1 oracle9i dba 104861696 May 3 15:43
ora_emp_inde_BEakGfun.dbf
./EMP_TABLE:
total 204808
-rw-r--r-- 1 oracle9i dba 104861696 May 3 15:43
ora_emp_tabl_BEak1LqK.dbf